Can I arrange these quarters like Q1,Q2,Q3 and Q4?

Kumar619
Kumar619 Member
in Charting

I have created calculated field Qno and assigned values Q1, Q2,Q3 and Q4 accordingly but it is showing like this in card ?

Qno.PNG

How can i arrange these ?

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    do you have Year in the ORDER BY clause? if so, then Q2 could be from different years. remove everything from your ORDER BY / sorting section of analyzer.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Kumar619
    Kumar619 Member
    edited February 2021

    No , years are not in Order by and this is for single year.

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    ... do you have quarter in the order by clause?

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Kumar619
    Kumar619 Member

    @jaeW_at_Onyx, No, I am not using any orderby clause. Simply created Quarters like this.

    image.png


  • Kumar619
    Kumar619 Member

    @jaeW_at_Onyx, No, I am not using any orderby clause. Simply created Quarters like this.

    image.png


  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    edited February 2021

    ... so use an order by clause on quarter if you want it to sort by quarter.


    image.png


    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Kumar619
    Kumar619 Member

    Thank You so much . It worked Thanks..

Categories