We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi Row inquiry

Mo1995
6 - Meteoroid

I have the following table

 

Mo1995_0-1627994680377.png

 

Each plan has 2 lines (Beg & End sub) I Want to get the average for each month

so I end up with a total of 5 columns, the fifth column shows the Average for each plan for each month

I'm confused which formula to use

 

Fos clarification I want for plan 12 PT, Jan 2020 to add beg+end and then divide by 2 and the result shown as the average and repeat onwards.

7 REPLIES 7
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Mo1995 ,

 

Can you share sample data ?

Mo1995
6 - Meteoroid

HYG

Jean-Balteryx
16 - Nebula
16 - Nebula

I crosstab the data to get one column for beginning and one for ending then divide the sum of them by two in a new column. Here it is !

IraWatt
17 - Castor
17 - Castor

This workflow should achieve what you want (attached below):

 

IraWatt_0-1627995644248.png

Use a summarize tool grouping by MM-YYYY then taking an average:

IraWatt_1-1627995671270.png

Then join the output with the data using a join tool based on MM-YYYY:

IraWatt_2-1627995768689.png

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.


Kind Regards,
Ira

 

atcodedog05
22 - Nova
22 - Nova

Hi @Mo1995 

 

My take on this using multi-row formula tool.

 

Workflow:

atcodedog05_0-1627995930144.png

 

Hope this helps : )

 

Mo1995
6 - Meteoroid

Thanks alot !

 

worked like a charm

Jean-Balteryx
16 - Nebula
16 - Nebula

You are welcome @Mo1995 !

Labels
Top Solution Authors