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

CGodfrey's avatar
CGodfrey
Frequent Visitor
2 years ago

Replying to this late but I have another solution.

When I tried dropping in the year and quarter into the X-value I couldn't get the order right. I would sort by quarter, or year and it would always end up wrong. Then I tried drilling up and down in the chart to get the years to appear below the quarters, no luck. I also tried these methods with and without concatenate in the Format Visuals -> X-axis -> Values menu. Nothing. 

What ended up working is creating a hierarchy and then dropping the hierarchy into the visual instead of the individual values. Hope that helps someone else.