Hello community!
Reaching out for your help:
I´m trying to re-apply this Excel formula in Alteryx:
As you can see I need to create a column that for each period calculates the average of the column at the left of it but only for the values that are in the same month.
For example:
If the period has the month January, the value in column H will be the average of all the other values in column G that also occur in the month January, if we have 2 years we have 2 Januaries, In this case we have 10 years of data, that´s why there are 10 values that we need to calculate the average for.
Please help!!
