cancel
Showing results for 
Search instead for 
Did you mean: 

Rank based on each month

tsaho8
7 - Data Storage
7 - Data Storage

Hi @Angelina_QBeeQ ,

I want to set the rank independently for each month based on measure.

Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date])

As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on..but now it is not considering individual months while calculating rank.

tsaho8_0-1684222544910.png

 

4 REPLIES 4

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @tsaho8 ,

Try adding asc/desc to your rank formula, like this:

Angelina_QBeeQ_1-1684223863953.png

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ  - Gold Implementation and Development Partner

 

Hi @Angelina_QBeeQ ,

Still getting the same.

tsaho8_0-1684227063480.png

 

tsaho8
7 - Data Storage
7 - Data Storage

Hi @Angelina_QBeeQ ,

Could you please help me on this.

Regards,

Tulu

Hi Tulu,

In some versions, the rank function does not work properly when you need to group by option. What you can try:
- Write in rank "rank type" (1234,1224 etc) first and then asc/desc. I saw this issue in version L2023.2.
-Try turning off the analytical engine and check the rank again.It may take some time for the changes to be applied.
- Discuss the case with Sisense support.
- Make a custom table for your needs in the EC.

Kind Regards,
Angelina