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

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

How can i arrange these ?

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    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.

  • Kumar619
    Kumar619 βšͺ️
    edited February 22

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

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

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

  • Kumar619
    Kumar619 βšͺ️

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


  • Kumar619
    Kumar619 βšͺ️

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


  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀
    edited February 22

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



  • Kumar619
    Kumar619 βšͺ️

    Thank You so much . It worked Thanks..

Sign In or Register to comment.