Bar Chart by the Hour
I wish to create a bar chart showing the number of orders taken today by the hour e.g 8-9, 9-10, 10-11 and so on. Is this possible. The group by box doesn't seem to offer time based options? I h...
Forum Discussion
np
just make for your own text formula field or time of day formula field to bucket the ties by hour, and then group on equal values.
If you use a formula text field you will need to contrive to have them list in alpha sequence to ensure that 9:00 am is before 1;00 pm., so you may need to ad a leading space.
for example
var TimeOfDay Time = ToTimeOfDay([my date / time field]);
IF(
$Time < ToTimeOfDay("7:00 am"), " Before 7:00 am",
$Time < ToTimeOfDay("8:00 am"), " 7-8" ,
$Time < ToTimeOfDay("9:00 am"), " 8-9" ,
etc
$Time < ToTimeOfDay("1:00 pm"), " 12-1" ,
$Time < ToTimeOfDay("2:00 pm"), "1-2" ,
$Time < ToTimeOfDay("3:00 pm"), "2-3" ,
etc
)
just make for your own text formula field or time of day formula field to bucket the ties by hour, and then group on equal values.
If you use a formula text field you will need to contrive to have them list in alpha sequence to ensure that 9:00 am is before 1;00 pm., so you may need to ad a leading space.
for example
var TimeOfDay Time = ToTimeOfDay([my date / time field]);
IF(
$Time < ToTimeOfDay("7:00 am"), " Before 7:00 am",
$Time < ToTimeOfDay("8:00 am"), " 7-8" ,
$Time < ToTimeOfDay("9:00 am"), " 8-9" ,
etc
$Time < ToTimeOfDay("1:00 pm"), " 12-1" ,
$Time < ToTimeOfDay("2:00 pm"), "1-2" ,
$Time < ToTimeOfDay("3:00 pm"), "2-3" ,
etc
)