Hi guys,
I have wha I think is a bit difficult task. I need to calculate an average for each area and each KPI and visualize in a tableau dashboard. The dashboard looks as follows and I would like to add an extra column that has the average of the months in the current year.
I was thinkiing of doing it in alteryx. Do you have any suggestions,
My data looks like this:
i was thinking of add a summarize tool in alteryx tnad the group by area, kpi, year and average over the value, however it doesn't seem to make sense when I want to add it in the dashboard in tableau.
Hope ypu guys can help!
