Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert a monthly total from a quarterly average

ksmith
5 - Atom

I am trying to figure out a way to take the data below that is average data by quarter (Current View) and reverse it so that the data is populated for each month (Expected View). 

ksmith_0-1646852399751.png

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @ksmith 

 

Here is how you can do it. I have slightly changed the input so that you can make out that it works with different data.

Workflow:

atcodedog05_0-1646853558414.png

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @ksmith 

Cheers and have a nice day!

Labels
Top Solution Authors