Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
20
Report Grouping
posted

Hi Guys,

Quick one for you;

Is there any way to apply grouping to a report? I'm looking to run hourly sales reports 1-2,  2-3, 3-4 etc, I have tables for Time but only seem to be able to display all times and can't see an option to group them by hour.

Thanks,

Brian

  • 225
    Verified Answer
    Offline posted

    Hi Brian,

    I've tried with a few examples and came across a solution that I believe will fit your need:

    As there are no time filters for hours just as you commented, I created a "Day" calculated field, using a function of the same name to return the day number as an integer: HOUR(DATE(year,month,day,hour,minute,second))

    Take a look at the Help Guide explanation for Calculated Fields here

    If your current field is called TIME, then the new calculated field would be defied simply with the expression: DAY([TIME])

    Then, I had to repeat the process creating a second field: HOUR([TIME])

    Two more small steps. Select each of the new fields, then Formatting, then change the Fraction Digit to cero, otherwise it will look strange. Regretfully, the day number and the hours are considered integers now.

    Finally, with both fields created you can now drag them to the Filter section.

    After you save the Dashboard, you can now filter on the right-hand side first by "Day", manually, then the "Hour".

    Hoping to have helped,