How can I develop a report to have break up time by intervals.

[Poloxstar]

Please help? I am trying to create a report to count how many transaction are taken in 30 minute time frames. I am stuck on how to create a formula to have the time intervals. Don't know where to begin.

example
Time Count
7:00 am 8
7:30 am 9
8:00 am 10

Thanks

 

[lbass]

It depends in part on the datatype of your time field, but if it is a time field, you should be able to create formulas like:

if {table.time} in time(07,00,00) to time(07,30,00) then "7:00 to 7:30" else
if {table.time} in time(07,30,01) to time(08,00,00) then "7:30 to 8:00"//etc.

Then group on this formula and insert summaries on your transaction field. Then suppress the details.

-LB

 

[synapsevampire]

Note that if your data does not have any transactions for a given timeframe, then you won't get that time with a zero quantity, it will be omitted.

I generally approach this sort of requirement by creating a table with all times at the 1/2 hour level (data warehousing dimension table approach).

-k