Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why don't you use the Hour() function 10 to 10:59:59 will all fall under 10th hour of the day....
Or maybe this
=SubField(completed_date, ':', 1) & ':00'
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])
May be do this
Floor([completed_date], 1/24)