Challenge #9: Analytics Ranking

[S_Summers]

Joining in with the challenges after loving the 'Weekly Challenge' session at Inspire Europe 2018 :) 

[pasccout]

Here is my solution

[gmitch22]

... now if I could just figure out how to delete a double post.

[gmitch22]

Used two tools: 

Sort: count (descending); First (ascending - not necessary but did it anyway)

Multi-Row Formula: "IF [Row-1:count]!=[count] THEN [Row-1:Rank]+1 ELSE [Row-1:Rank] ENDIF"

[mridenour]

gmitch22,

This is good. However, in many cases, clients wish to see rankings like this (example): 1,2,2,4,5,6,6,6,9,10. This formula would produce an output that looks like this (example): 1,2,2,3,4,5,5,5,6,7. Using the record ID tool, each row can be given a number (after using the sort tool), so the number of record are preserved. Something like this in the multi-field formula tool:

IF [RecordID] = 1 THEN 1
ELSEIF [Row-1:count]=[count] THEN [Row-1:Rank]
ELSE [RecordID]
ENDIF

If there are subgroups that need to be ranked, a filter can be applied to each subgroup (after being sorted), each of those given a record ID, and the results can then be unioned together, and the aforementioned formula can then be applied in the multi-field formula tool to resolve tiebreakers and preserve the number of records. Hope this helps!

[Mac]

My take on it...

[NilsM]

Spoiler

 My solution

[gmitch22]

Thanks!

[richard_butler]

Just seen these challenges - they seem great!

[grodge13]

Spoiler

1. Sorted by count
2. Used the multi row formula tool to calculate the ranks
3. Filtered where rank <= 5