10 Replies Latest reply on Sep 14, 2016 1:33 AM by kettan

    Create groups from Time formatted as a Number (Decimal)

    Eileen Lee

      Hi Tableau Community,

       

      I need help with the following please. I have a column named "Start Time" which has been and must be formatted to Number (Decimal) in Tableau. The column would look like this.

       

      Start time

      02:00

      02:05

      02:35

      03:25

      04:15

      05:05

      06:05

      06:55

      07:45

      08:35

      09:30

      10:25

      11:15

      12:05

      12:55

      13:45

      14:40

      15:30

      16:25

      16:55

      19:20

      20:15

      21:10

      22:05

      00:10

      01:05

      01:55

       

      I need to create 2 groups from this column - anything that falls within 18:00 to 00:59 as "Group A" and anything else would be "Group B".  Purpose of grouping is so that I can use these 2 groups as filters later on.

       

      Please advise how I can create the 2 groups. Thank you!