In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
This is a nice quest not only to get familiar with Designer Cloud but also, to know how the behavior of the tools having the same name differs between each platform Desktop vs Cloud. With Designer Desktop, I would go with Tile tool to calculate Dense Rank. With Designer Cloud, I see a couple of way to do so.
Spoiler
Tile tool in Cloud has mandatory option of "Sort by" while Desktop has an option "Leave Unsorted". I could not find the way to directly put dense rank in descending order by solely using Tile tool.
I was surprised by the output of the tile tool. Fun challenge though :)
Spoiler
Its Tile_nums were identical regardless of sort order, or sorting before the tool
This one required me to use different tools than I would normally use with Designer Desktop. Also, requiring a sorting column for the Row ID tool removed a solution for me on this one. I get it has to do with sampling on the backend, but it's very frustrating sometimes.
