How do I sort x axis of a chart in dashboard?
![msr](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar19.png)
msr
Partner, Registered Posts: 9 Partner
- The x-axis is date and it is coming in jumbled order
- The x-axis is string but in different charts the same values are coming in different order
How can this be fixed?
Operating system used: Windows
Tagged:
Best Answer
-
Hi @msr
,You can change the sort order of the X-axis by clicking the ▾ arrow next to the column name in the chart editor. You can sort by natural (alphabetical) order, or sort based on the record count.
Also, for your chart that's using a date, I could be wrong, but it looks like the type of the "Metric date" column might not actually be a date. Could you please verify that the type is correct in the dataset?
If it's not a date, you might need to parse the date first. See this article for more information: Managing dates.
Thanks,
Zach
Answers
-
Thanks a lot @ZachM
!It helped. Yes it wasn't date, I have it now and it is now working as expected.