Kusto Detective Agency Season 2 - Onboarding Badge

Walk Through Guide for Kusto Detective Agency Season 2, Onboarding Solution

Cases Solutions: 0 1 2 3 4 5 6 7 8 9 10

Get ready detective, because season 2 of your favorite season is back! 🕵

The onboarding riddle is:

The key takeaways from the riddle:

1. There are different detectives working on cases to get bounties 🌟
2. Only the first detective to crack the case gets the bounty 🥇
3. We are asked to find the detective that earned the most money in 2022 🤑

⚠SPOILER ALERT — THE SOLUTION DESCRIBED BELOW⚠

Note: Solution is mine, and non-official

So let’s delve into the data, by leveraging the | take 10, to see some rows.

The DetectiveCases table has; Timestamp, EventType, DetectiveId, CaseId, Properties.

We can notice that bounty is described at Properties field, for records where EventType field is CaseOpened.

So we need to extract for each case it’s bounty:

Now, let’s find for each case who was the first lucky solver:

Finally, we can combine them to get the solution:

Enjoyed this article? Feel free to long-press the 👏 button below 😀

Click for Next Case Solution ➡

Cases Solutions: 0 1 2 3 4 5 6 7 8 9 10