We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
Solution approach:
1. Impute the null values per RM category and Year. Despite some solutions impute 0 the temporal series value, I use the median value
2. Create the moving average for 3 nd 6 months for each requested field
3. Perform the cross tab
PS. if anyone has the spoiler code button, please let me know :)
this one gives quite a bit of frustration, but I figured it out. It matches the expected output.
Spoiler
The instructions says for Values that do not exist, set values to closest valis row. This, I was assuming was for multi-row formula tool. For 3mo average and 10rm 6mo average, it used just that. For all other 6mo average, it calculated only on the months available and divided by 6. ie single month value divided by 6....2 month values divided by 6...etc.
For sorting, the original data found in the output is sorted to original column order. For 3mo and 6mo averages, they are sorted in alphabetical order.
The origin of the 3mo and 6mo average name are not helpful either.
For sorting, the original data found in the output is sorted to original column order. For 3mo and 6mo averages, they are sorted in alphabetical order.
The origin of the 3mo and 6mo average name are not helpful either.
had this one sitting around for a few months cause it looked way too annoying
will have to check the official solution, because I doubt this is how it is supposed to be solved
