Search

Close

Start Free Trial

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

Not as difficult as I expected.

Solution Image.png

Screenshot 2025-01-29 100626.png

Spoiler

My solution:

Challenge 451 Workflow Pic.png

Json Parse made this straightforward

Solution without using JSON and Regex:

Step1: Use text-to-column to split the data on basis of delimeters (:,)

Step2: Use replaceChar in formula to remove all the unnecessary special characters

Step3: Summarize on the basis of Year-Month and average the required parameters.

Step4: Sort the data and use the output again to Summarize the median for both the parameters.

Did some fancy schmancy new (to me) things! Pretty cool!

Solution to challenge #451

Done!

Here is my solution.

Live Weekly Challenge