Forum Discussion

PeteJames's avatar
PeteJames
Qrew Cadet
6 years ago

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 have fixed this by creating an new field which converts date created to the hour and grouping by equal value..

reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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

    )