yearly moving average tableau or alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Data Investigation
- Datasets
- Developer
- Tableau
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Easy peasy in Tableau using level of detail expressions to fix the average at the year, area, and kpi level (basically excluding month).
Also easy peasy in Alteryx using the summarize tool, you'll just need to be careful with the aggregation you select in Tableau (ie. summing up multiple rows of the same data will give you an artificially high value. Instead, you'd want to use a MIN or MAX).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
w in tableau exactly? @raychase
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's an example I created that you can download and tweak as necessary. I misunderstood your original ask, but it's still easily doable using two separate sheets strategically arranged to look seamless.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much! That was exactly what I was looking for!
How do you laign the two so they fit perfectly to the correct KPI? :--)
