topic Re: Grouping in Dimension in App Development

Grouping in Dimension

Anonymous — Thu, 06 Sep 2018 18:13:29 GMT

I have a time field, completed_date, that is continuous. Trying to create a new dimension that groups any time within a certain hour under whatever hour it is.

For example:

10:00:00 - 10:59:59 would be grouped under 10:00

11:00:00 - 11:59:59 would be grouped under 11:00.

Any way to do this? If so, any example or expression setup? Thanks in advance.

Re: Grouping in Dimension

sunny_talwar — Thu, 06 Sep 2018 18:26:18 GMT

Why don't you use the Hour() function 10 to 10:59:59 will all fall under 10th hour of the day....

Re: Grouping in Dimension

andrey_krylov — Thu, 06 Sep 2018 18:30:27 GMT

Or maybe this

=SubField(completed_date, ':', 1) & ':00'

Re: Grouping in Dimension

Anonymous — Thu, 06 Sep 2018 18:49:28 GMT

Using Hour() function shows me sales at that hour, but it groups all days together as well. Kind of want Hours to be grouped per day, thanks though. I tried Hour([completed_date])

Re: Grouping in Dimension

sunny_talwar — Thu, 06 Sep 2018 18:50:27 GMT

May be do this

Floor([completed_date], 1/24)