Top-Bottom_N_RankingExample.iok | 14K |
Top-Bottom_N_RankingExample[1].iok | 14K |
Capture.JPG | 48K |
Rank Desc
RANK([Data Values],[Data Values], false, false)
#ranking values in descending order, so the highest value has rank 1
One= 1
Running Total =
RUNNINGTOTAL([One], SUBSET([Rank Desc]))
#identifying shared rank values
Dense Rank Desc =
RANK([Data Values], [Data Values], false, false,
SUBSET([Running Total],1,"="))
#ranking every Data value only once
Dense Rank Asc=
RANK([Data Values], [Data Values], true, false,
SUBSET([Running Total],1,"="))
#Ranking ascending unique values
Top N values=
IF([Dense Rank Desc]<=[Top N],
"Top "+[Top N],
null)
#Variable "Top N" introduced to generate dynamic values
Bottom N values=
IF([Dense Rank Asc]<=[Bottom N],
"Bottom "+[Bottom N],
null)
#Variable "Bottom N" introduced to generate dynamic values
View Header Titles:
"{{ SUBSET_FIRSTNONNULL([Top N val]) }} - Dynamic value"
"{{ SUBSET_FIRSTNONNULL([Bottom N val]) }} - Dynamic value"
Top-Bottom_N_Ranking_Forum.iok | 27K |
Running total top=
IF([Top N val]<>null,
RUNNINGTOTAL([One], SUBSET([Top N val]),false),
null)
Running total bottom=
IF([Bottom N val]<>null,
RUNNINGTOTAL([One], SUBSET([Bottom N val])),
null)
RankedRecordSelection.JPG | 45K | |
Top-Bottom_N_Ranking_SELECTIVE.iok | 32K |
It looks like you're new here. If you want to get involved, click one of these buttons!