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

      Hello,

       

      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)

      Screenshot.png

      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
      Andy