We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
There seems to be a problem with the provided solution the Dynamic rename has errors and doesn't actually rename the field with the "r3Mo " and "r6Mo " prefix...
There are 2 solutions in my file... one that matches the output and one that is different but IMO has a more readable output... I assume the Rolling Moving Averages are used to compare the current value to gain some context on improvement or decline... when they are separated by so much it losses that context.
The problem statement is not easy to understand at all. The result adds to the misery as there is nothing you can get out of it. I would like it if someone would be kind enough to explain to me the problem. I have been stuck of this for the past hour not able to wrap my head around how to take the input, apply the moving average formulas, and end up with the result they have given.