Averaging

[Marialt]

I have to prepare some data that requires an average for each currency

In excel it is easy to fix the start point and then the end point moves for each month

CY PERIOD YY	PY PERIOD YY	EUR	GBP	JPY	USD
01/01/2017	01/01/2016	1.361299	1	178.3694	1.48225
01/02/2017	01/02/2016	1.312388	1	172.7818	1.42545
01/03/2017	01/03/2016	1.273851	1	156.8609	1.38665
01/04/2017	01/04/2016	1.26338	1	161.4815	1.4388
01/05/2017	01/05/2016	1.280258	1	156.6292	1.46135
01/06/2017	01/06/2016	1.313478	1	162.9867	1.46525
01/07/2017	01/07/2016	1.211384	1	138.2084	1.34615
01/08/2017	01/08/2016	1.18599	1	135.9866	1.32315
01/09/2017	01/09/2016	1.17687	1	135.486	1.31015
01/10/2017	01/10/2016	1.160904	1	131.2032	1.2976
01/11/2017	01/11/2016	1.11105	1	127.6891	1.2156
01/12/2017	01/12/2016	1.174437	1	141.5249	1.24825

So the formula average in excel for Jan EUR would be =AVERAGE($C$2:C2), Feb would be =AVERAGE($C$2:C3) etc

How do I replicate this within Alteryx

[jdunkerley79 · Accepted solution]

A couple of steps to achieve this:

1 - Add a Record ID tool (this will just add a record number for a count)

2 - Use the Running Total tool to create totals for each Currency

3 - Use a multi field formula to create an average value.

You can then clean up with a select tool.

Sample attached

[Marialt]

Thank you so much, works perfectly