8 Replies Latest reply on Feb 6, 2017 11:37 AM by Nicholas Zipp

    How do I add an average to a graph?

    Andreas Linden



      I am struggling to add a line to a line graph representing an average revenue for each month across all categories... should be simple but seemingly not! I am charting time on the horizontal axis and revenue on the vertical axis, with product category represented by lines with different colours (see screenshot)


      I've tried adding a calculated field to the chart but Tableau then generates lines representing averages for each product category, rather than an average for all product categories, for each month.


      Adding a reference line of averages also doesn't work as the line represents the average for the entire dataset rather than varying by month.


      Any help would be much appreciated.


      Many thanks