Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Nice and simple, and a lovely shout-out to the Sample tool.
Spoiler
I simply applied a filter to take only those marked as a Hot Technology, then summed them in a sum tool grouped by the Name field, then a count of the same. This will give you the amount of instances of each name.
I then sorted them descending by count and Sampled the first 3.
This gave the first answer. The second part was simply a matter of taking the records from the filter, before the aggregation and joining them on name. this gave the top three technical skills but un-aggregated, so the most granular level of data. I then sorted the records by title.
I then sorted them descending by count and Sampled the first 3.
This gave the first answer. The second part was simply a matter of taking the records from the filter, before the aggregation and joining them on name. this gave the top three technical skills but un-aggregated, so the most granular level of data. I then sorted the records by title.
