Seeing X axis data in chronological order

mhealy
mhealy Member
edited March 2023 in Datasets

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
    mhealy Member
    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

  • mhealy
    mhealy Member
    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.