Cross-Tab by Half Hour 1

[kmcclung]

I am creating a cross-tab report for the # of occurrences by half an hour for a day. I am using a date/time field as the row (only displaying the time) and have edited the Group Options for the field so a row will be printed "for each hour". It works great except I need it for every half an hour and that isn't an option. Any ideas?

 

[skuhlman]

create the following formula and then build your crosstab on it.


datetime(year({MyTable.MyDateTimeField}),
month({MyTable.MyDateTimeField}),
day({MyTable.MyDateTimeField}),
hour({MyTable.MyDateTimeField}),
(if minute({MyTable.MyDateTimeField})<30 then 0 else 30),
0)

 

[kmcclung]

If I create the formula above and add it as a row, the cross-tab only prints the entire day on one row and then a grand total row. I then tried changing the Grouping Options on the formula field to on every hour and get the same results as I do when I don't use the formual and just the date field.

 

[skuhlman]

Using that formula, group it on EACH MINUTE. Everything within the same half hour period will have the same minute in the formula.