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



      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.