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

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