Cloud Quest #3: Ranking Duplicate Data

[RWvanLeeuwen]

Using my own datasource (which I had to deduplicate because it was hastily generated) I tackled this Quest #3!

Here's my take

スポイラ

the second aggregation step is to create te count per user, but as the tile tool inverses the rankings, I had to fix that using a max_tile + append + formula construction

[AkimasaKajitani]

My solution!!

I remember there was the similar challenge in Weekly Challenge. So I used Weekly Challenge #9's input file.

スポイラ

  

I attached my input file.

[alexnajm]

Thank you @AkimasaKajitani for providing a file! Solution attached:

スポイラ

Similar solution as well - is it just me or did the Tile tool not perform as expected?

[biancang]

Done. ☺

スポイラ

[MikeRoof]

Big thanks to @AkimasaKajitani for the example file! Here's a solution that uses Unique instead of Summarize:

スポイラ

[tshih18]

Here's my solution

スポイラ

 

 

[Qiu]

Lets have the Multi-Row Formula tool for Cloud

@AkimasaKajitani Thank you forthe data input.

スポイラ

[LynnPätzold]

Had to think a sec about my solution.

スポイラ

 

[Ladarthure]

My solution! loving the record id function with a sort integrated! 

thank you @AkimasaKajitani for the dataset :)

スポイラ

 

[nwaters]

Here is my contribution for Cloud Quest 3

スポイラ