Cloud Quest #3: Ranking Duplicate Data

[DaanVerkerk]

Had to solve this differently than I might have on Desktop, this is exactly the reason why doing cloud challenges is so good!

Spoiler

[andrewgu]

Spoiler

Solved during the Australian Cloud Weekly Challenge Hour by myself, @leofrancia , Jimmy and Charlie!

[nadasky]

My solution.

Spoiler

 

[Diederik_vanderharst]

Now with flow

[bradshaw]

This one was nice

Spoiler

[TigiPaz]

Had to use a little help from spoiler, go it (3)  😊 

Also, figured out using tile (3.2)

[Dlawless610]

 Here is the workflow I created for a solution. 

 

[BS_THE_ANALYST]

Interesting that the tile tool doesn't rank like it does in Designer. For example, I have my rows sorted in a descending order, based on a column. I select "unique value" on that column, using the tile tool. It then returns the ranks but in reverse order i.e. largest rank assigned to the first row it sees. 

Spoiler

 

 

 

 

All the best,

BS

[Tom_Pilgrem]

Here's my solution 

Spoiler

 

[mceleavey]

I might have done this slightly differently in Designer, but a simple one nonetheless.

Spoiler

I simply created a grouping of unique values and gave them a RowID (Rank) sorting by Value Descending, so the highest value is the lowest ranking number. I then sampled the first 5 ranks.
I then joined these values back to the primary stream and sorted accordingly.