Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unable to last sort 24 hours.

I want to show X-Axis with last 24 hours. If time now is 12 pm , then i have to show 12Pm now to 1 PM yesterday.

Problem here is when i am trying to sort in modeling, it throws error. because it has too many same values to sort.

 

Date                Hour      Min       Avg Time

4/1/19 10:00 AM1000.402727
4/1/19 9:59 AM9590.080909
4/1/19 9:59 AM9590.046
4/1/19 9:58 AM9580.065384
4/1/19 9:59 AM9580.07
4/1/19 9:58 AM9580.186666
4/1/19 9:57 AM9570.22
4/1/19 9:57 AM9570.077857
4/1/19 9:57 AM9570.197333

 

the graph is sorting like numbers from 0 to 23 or 23 to 0.

But i need like  17  18  19  20  21  23  0  1  2  3  4  5  6  7  

 

Thanks

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It will always sort from 13 - 12 like 13 14 15 16 17 ------- 10 11 12

      But i need according to current time. 

      if time now 8m , Sort should be 8 7 6 5 4 3 2 1 0 23 22 21 20 --------- 12 11 10 9 .

      v-cherch-msft wrote:

      Hi Anonymous 

      You may add an index column for the hours column.Then use sort by column.Attached sample file for your reference.

      Regards,