Hi Community,
We posted the solution JSON file to Cloud Quest #43. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
- Download the provided ZIP file containing your starting data and workflow files.
- Upload Start Cloud Quest 44.json to your Alteryx One library.
-
Reconnect Quest44Input.csv and Quest44Output.csv to their respective Input Data tools in your starting workflow.
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.
Scenario:
Rolling averages, also known as moving averages, smooth out short-term fluctuations in data so you can better see long-term trends. A 3-month rolling average shows more recent shifts, while a 6-month rolling average provides a broader view of the data.
For this week’s Quest, your goal is to:
- Create 3 and 6 month running averages for the values contained in columns: c.LK98, p.LK98, c.1K, p.1K, c.NLP3, and p.NLP3.
- Append the averages to the original table ensuring results remain grouped by RM Category, Year, and Month.
For Example:
|
Month
|
Value
|
Running 3 mo. Average
|
|
1
|
218
|
218
|
|
2
|
200
|
212
|
|
3
|
272
|
233
|
Hint:
Flex your abilities with the Multi-Row Formula tool! For values that do not exist, replace with zero.
Image: https://en.wikipedia.org/wiki/Moving_average#/media/File:Lissage_sinus_bruite_moyenne_glissante.svg
Earn Cloud Quest badges:
After completing your quest, head back to your Analytics Cloud library:
- Download your workflow solution file.
- In your reply, attach both your JSON solution file and a screenshot of your workflow.
- Keep submitting—every solution gets you closer to earning more Cloud Quest badges!
Here’s to a successful quest!
- The Academy Team
Download Start File
