Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
mhapanka
Creator
Creator

Sorting the X axis numericially isnt working

Hi in the graph below, i want the x axis to read - 2016-Q1, 2016-Q2 , 2016-Q3 and so on till 2018-Q3 so I sorted numerically with 'Fiscal year/ quarter' being the first to be sorted by however that is not happening and the years are all muddled up. How do I fix this?

5.PNG

1 Solution

Accepted Solutions
sibin_jacob
Creator III
Creator III

Select the Sort by Expression option, then use the below expression.

NUM(Replace(Year_Quarter,'-Q',''))

Then Select Ascending.

View solution in original post

4 Replies
uroboros
Creator
Creator

Hi Malika,

It because the data set that you need to sort have a text format; try sort with one expresion or with a date field!

Regards!

nestigeek
Contributor II
Contributor II

Try Sort by Expression and use your Date field

sibin_jacob
Creator III
Creator III

Select the Sort by Expression option, then use the below expression.

NUM(Replace(Year_Quarter,'-Q',''))

Then Select Ascending.

balabhaskarqlik

May be try like this:

Date(Aggr(Max([Close Date]),FinancialYear/Quarter),'YYYY-MM')