Challenge-03

Challenge - 03 : Running Averages

Problem Statement :

Create 3 and 6 month running averages by RM Category for the values contained in columns:

• c.LK98
• p.LK98
• c.1K
• p.1K
• c.NLP3
• p.NLP3

Here is the weekly challenge link in the Alteryx community: Challenge #3: Running Averages

Concept & Highlights Covered :

This challenge covers the following concepts:

• Data Preparation

The Alteryx tools and techniques that can be used to solve this challenge are as follows:

• Prepare
• Join
• Parse
• Transform

The proficiency level required to solve the challenge is : Intermediate

Solution :

Here is the snippet of the workflow that achieves the required result: