Grouping in Dimension

[Anonymous]

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.

[sunny_talwar]

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

[andrey_krylov]

Or maybe this

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

[Anonymous]

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])

[sunny_talwar]

May be do this

Floor([completed_date], 1/24)