Forum Discussion

mohamedm's avatar
mohamedm
Frequent Visitor
1 year ago
Solved

I have Timing Order but Chart is getting sort by value

Dear All,

 

i have timing_hour

00-01

01-02

02-03

 

the data values, when i add this to chart order based on value hight value coming first , i want to make timing order anyway i can do ?

chart should 00-01 , 01-02 etc..

 

 

Need Help
  • Uzi2019's avatar
    Uzi2019
    1 year ago

    Hi mohamedm 

     

    Try to sort then chart by time value column.

     

     

     

     

    sort by time value instead of numeric value.

     

    Click on 3 dots of your chart > sort by select field name > Asc/desc

     

    I hope I answered your question!

     

     

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Hi mohamedm 

     

    Try to sort then chart by time value column.

     

     

     

     

    sort by time value instead of numeric value.

     

    Click on 3 dots of your chart > sort by select field name > Asc/desc

     

    I hope I answered your question!

     

     

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    1 year ago

    mohamedm You can create a calculated column that extracts the hour part of your timing_hour values.

     

    SortOrder = VALUE(LEFT([timing_hour], 2))

     

    After creating the SortOrder column, go back to the "Data" view.
    Select the timing_hour column.
    In the "Column tools" menu, click on "Sort by Column" and choose the SortOrder column.