How do I sort x axis of a chart in dashboard?

Tags
Partner, Registered Posts: 9 Partner
  1. The x-axis is date and it is coming in jumbled order
  2. 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

Best Answer

  • Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 153 Dataiker
    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.

    996A9237-2009-424F-8C44-75D58666ECF6_1_201_a.jpeg

    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?

    9322AED7-687C-4FD4-81C3-9C2295CA93DC_1_201_a.jpeg

    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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.