Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution: https://youtu.be/9FwiR0kQwGQ
Hi everyone
below I am attaching my solution.
To solve the question I used three tools:
1) Sort tool to sort the data in descending order;
2) Formula Row tool to create the rank column based on the following formula:
IIF([count] != [Row-1:count], [Row-1:Rank] + 1 , [ROW-1:Rank] )
3) Filter tool, to filter data based on rank
In my opinion, a specific tool should be created, to create classifications and rankings, perhaps with the possibility of considering multiple fields, or formulas
Especially for Top and Bottom (N) analysis
Hi everyone