BusinessObjects Board

Group and count based on time

building reports
#1

Good day, I want to group time stamps into selected counts. I am converting time fields in a format: HH:mm:ss.
I am creating a table with the following headings and want to group the data into groupings and count occurrences:
0 - 5 minutes; 5 - 10 minutes; 10 - 20 minutes; 20 - 30 minutes; >30 minutes.

At present I am creating my output as below.
The formula for my variable named Calc_New-EnRoute is:

FormatNumber((Floor([Calc_New-EnRte(sec)]/3600))/24;"0")+":"+
FormatNumber(Floor(Mod([Calc_New-EnRte(sec)];3600)/60);"00")+":"+
FormatNumber(Mod(Mod([Calc_New-EnRte(sec)];3600);60);"00")

I now need to take that output, group it then count occurrences, any assistance will be appreciated

#2

use a new variable to check all your grouping-conditions and give it a text-result of e.g. „0“ „5“ „10“ „20“ or „30“ so you finally can show/count everything with e.g. „20“

1 Like