How to group by time without seconds

BIRTigo
edited February 11, 2022 in Analytics #1
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.

Comments

  • Virgil Dodson
    Virgil Dodson E admin
    edited December 31, 1969 #2
    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
    Warning No formatter is installed for the format ipb