Hi all,
This is my third problem i have posted and so far I’ve had 100% success, so i’m hoping this one will get solved too.
As you can see from the chart below, the data is being sorted by the y axis, as in the higher value or greater amount. I actually want the x axis to be sorted in weeks. In this example i’d want it to look like 06-2020, 07-2020, 08-2020 and last 09-2020.
Any ideas?
Best answer by asanka
Just make sure the data source order by is set up so that it sorts by the column which you use for x-axis. Never been a problem.
We used a concept in the order by (Data Source Designer) like this:
to_char(date_entered,'MM'), to_char(date_entered,'DD'),to_char(date_entered,'YYYY')
For what you are showing something like:
to_char(date_entered,'MM'), to_char(date_entered,'DD')
Just make sure the data source order by is set up so that it sorts by the column which you use for x-axis. Never been a problem.
Thank you all for your help.
I Found out a much simpler way of doing it. I simply used the ORDER BY ‘week’ in the Data Source Designer and its sorted the x axis perfectly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
