Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sort Line Graph Newest to Oldest

 

I would do display this graph with the most recent values on the left and the older values on the right.  Please advise.

 

 

 

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    Hi Anonymous

     

    I would suggest going into the Query Editor and making sure that the Data Type is set to DateTime. Once that has been done, the data should be re-loaded and the sorting option should appear

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    Hi Anonymous

     

    What you would need on your X-Axis is your date field so that it can show it over time. 

     

    If the sorting is still out you can click on the three dots "..." and it will give you the option to "Sort By", then select Sort By Date if that is your column name and the line graph should then show it in the correct way.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      The options after clicking the three dots are:

      • Export data
      • Show data
      • Remove
      • Spotlight

      So, I assume it's because the x-Asis is not formated as a date field.  Which might be true, but doesn't solve my problem.  My x-Axis includes date and time.   It's reading a cell I get every hour coming from an Excel spreadsheet, which is in Date format, specifically " [$-en-US]m/d/yy h:mm AM/PM;@  ".  

       

      I can't "sort" on that and haven't figured out a work around.

       

      Thanks 

       

       

       

       

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago

        Hi Anonymous

         

        I would suggest going into the Query Editor and making sure that the Data Type is set to DateTime. Once that has been done, the data should be re-loaded and the sorting option should appear