Challenge #9: Analytics Ranking

[ganeshnaicker]

Hi All,

My solution is different from the solution provided and it takes few steps than the solution

[Falk]

[ryan_b]

Just completed my first challenge.

[Kdpalmer]

Can anyone explain the following: when I add a multi row formula for a rank column and group by "count" it always starts from the lowest count number, even when I  put a sort tool to have count in descending order (i.e. I was attempting to have "17" be at the top of the data set, and all names with 17 to be ranked "1" but could not achieve this with simply grouping by count and trying to sort by descending)? Thanks!

[goncalopereira]

My Solution.

[mjholland]

I tried to add in a rank column without splitting the input in 2 directions, which I struggled with. Splitting them was much easier, who knew?!

Spoiler

[AlexWHW]

Easier than #8... hmmm 

Spoiler

[lainecaruzca]

Spoiler

Spolier

[NilsM]

check out my solution:

Spoiler