Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago
Solved

Sorting the Column Name

Hi BI Community Team,

 

I have created the new column name "time session" but after tried to build the visual and it didn't sort/range as the screenshot below.

Any suggestion to sort/rang it?

 

Thanks and Regards,

Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi, create another column

     

    Time Session_Index = SWITCH(TRUE(),
    [Log_In] < TIME(8,0,0), 1,
    [Log_In] < TIME(12,0,0), 2,
    [Log_In] < TIME(13,30,0), 3,
    [Log_In] < TIME(17,30,0), 4,
    [Log_In] < TIME(21,0,0), 5, 6)
     
    Then, click on the first column, go to column tools, select sort by column and sort by time_session_index

2 Replies

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hi, create another column

     

    Time Session_Index = SWITCH(TRUE(),
    [Log_In] < TIME(8,0,0), 1,
    [Log_In] < TIME(12,0,0), 2,
    [Log_In] < TIME(13,30,0), 3,
    [Log_In] < TIME(17,30,0), 4,
    [Log_In] < TIME(21,0,0), 5, 6)
     
    Then, click on the first column, go to column tools, select sort by column and sort by time_session_index
    • ADSL's avatar
      ADSL
      Post Prodigy
      3 years ago

      Hi olgad,

       

      Thank you very much for your helpful feedback.

       

      Best Regards,