10 Replies Latest reply on Nov 26, 2017 7:52 PM by Zhouyi Zhang

    Creating an Overall Average Reference Line when Filtering, with multiple Dimensions

    Kate Mahler

      Hi,

       

      Thank you in advance for your help! I need to create an
      average reference line for all my brands, but I am running into problems
      because I also need to filter the actual results. I also want the average per
      audience and KPI, and I don’t know if that’s adding too much complexity to it.

      So this is what I have now. This is filtered by ‘Brand x’:

       




       

       

      And ideally, what I would want is the average of all my 22
      brands per KPI and per audience.

       


       

      If anyone could help me crack this I would be very appreciative! Let me know if you need me to clarify anything.

       

      Thanks,

      Kate