2 Replies Latest reply on Sep 30, 2016 3:58 AM by Winson Lui

    Displaying the average of all data and an average of a particular month in one graph

    Winson Lui

      HI,

       

      The dataset contains the sales figures and the corresponding date.

      Than, I applied a filter to see the sales figure of December particularly.

      I would like to put down 2 reference lines in the bar chart (Sales versus date).

      One is the average of sales in December and another one is the average sales along the whole year (all sales figures in the dataset).

       

      I tried to pur down an average reference line and it only applies to those who has been filtered in.

      Then , I tried to create a calculated field with window_average but it still showed the average of that month only.

      Would you please let me know how I can get that 2 reference lines in one chart?

      Thanks.