Rank based on each month

[tsaho8]

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.

[Angelina_QBeeQ]

Hi @tsaho8 ,

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

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

[tsaho8]

Hi @Angelina_QBeeQ ,

Still getting the same.

[tsaho8]

Hi @Angelina_QBeeQ ,

Could you please help me on this.

Regards,

Tulu

[Angelina_QBeeQ]

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