Rank based on each month

Question

Hi&nbsp;Angelina_QBeeQ&nbsp;,I want to set the rank independently for each month based on measure.Rank logic:&nbsp;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.&nbsp;

angelina_qbeeq · Answer

Hi&nbsp;tsaho8&nbsp;,Try adding asc/desc to your rank formula, like this:

Always here to help,Angelina from QBeeQangelina.bulgakova@qbeeq.ioQBeeQ&nbsp;&nbsp;- Gold Implementation and Development Partner
&nbsp;

angelina_qbeeq · Answer

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

tsaho8 · Answer

Hi&nbsp;Angelina_QBeeQ&nbsp;,Still getting the same.&nbsp;

tsaho8 · Answer

Hi&nbsp;Angelina_QBeeQ&nbsp;,Could you please help me on this.Regards,Tulu

Forum Discussion

Rank based on each month

4 Replies

Recent Discussions

Pivot Table widget - column headers and column data out of alignment

Blox conditional formatting up and down indicators

Remove Widget Title Box

Change Legend Category Names

Rename the Pivot Grand Total

Sisense

Support

Resources