4 Replies Latest reply: Sep 6, 2018 2:50 PM by Sunny Talwar RSS

    Grouping in Dimension

    Ism Qui

      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.