Ranking x axis by year then month with a series sort by alpha

ninagonzalez
ninagonzalez Member
in Magic ETL

I am trying to get an x axis to display in date order over multiple years while also sorting by a series. It is not working. I have tried beast mode following several suggestions on dojo, but nothing works.

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In the sorting properties, drag your date column in and sort by ascending, then drag in the column you are using for the series into the sorting properties below the date column and choose ascending. That should do the trick. If not, please provide screenshots to make it easier to see what might be going on.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In the sorting properties, drag your date column in and sort by ascending, then drag in the column you are using for the series into the sorting properties below the date column and choose ascending. That should do the trick. If not, please provide screenshots to make it easier to see what might be going on.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ninagonzalez
    ninagonzalez Member

    Thanks Mark, this worked!

Categories