How to group by time without seconds

BIRTigo

Hi,

if for example my data shows

_date_ || _cust_id
======||========
1:30:35 || 123
1:30:42 || 123
1:30:56 || 123

I need to count/group the data by cust_id and by date but without considering the seconds. please help. thank you.

Virgil Dodson

Hi BIRTigo,

When creating a group on a date or time field in a BIRT table, you can select the interval of month, day, year, minute, second, etc. So for you case, selecting to group by day, hour, or minute should work and ignore the seconds. You could also create a computed column on your data set that creates a new field with the seconds trimmed off.

I'm moving this thread to the "Designing BIRT Reports" forum