Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date (Year & Quarter) Sorting in a Graph

Hi All   I've got a supply and demand graph. Numbers wise my supply is a positive number and demand is a negative. The source is an excel spreadsheet. One of my columns is a text field which has fo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    System Undersatnd ordering based on String data type because it's look like there are no seperate columns for year and It's Quarters. 
    Easy way to do it by creat indexing for Year/Qn column. and set created index column as order referance for Yr/Q column.
    Check this: https://www.youtube.com/watch?v=4xapOrfLvbg

    Keep Going 
    Best Regards,
    Nirav

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

System Undersatnd ordering based on String data type because it's look like there are no seperate columns for year and It's Quarters. 
Easy way to do it by creat indexing for Year/Qn column. and set created index column as order referance for Yr/Q column.
Check this: https://www.youtube.com/watch?v=4xapOrfLvbg

Keep Going 
Best Regards,
Nirav