Seeing X axis data in chronological order

Hello,

 

I have created a card that shows revenue data by quarter. I want the quarters to be displayed in chronological order (Q1FY15, Q2FY15 and so on). Right now the card shows Q1FY15 Q1FY16 Q2FY15......etc.

 

How do I change the display of quarters to be in chronological order?

 

Thanks!

Michaela

Best Answer

  • mhealy
    Answer ✓

    The data in the excel spreadsheet I was using as my data set had a slight typo in one of the date entries. All the other entries were noted as Q4FY16 and one set of  data was entered as Q3FY-16 so rather than showing the data chronologically, DOMO pulled it in as Q1FY15, Q1FY16.... Once I found the typo and fixed it Domo put it in the correct chronological order.

Answers

  • Figured this one out.

  • Can you share your solution so we can mark it solved?

     

    Thanks!

    Dani

    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.