Forum Discussion
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...
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
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
