2 Replies Latest reply on May 2, 2018 9:01 PM by Andrew Lemon

    Reference line average

    Andrew Lemon

      Hello All,

      I have a quick question. I'm trying to add a reference line one the attached visualization. I was able to quickly add a simple reference line that shows the average of measure field Discount C. This is not exactly what I need.

      What I'm really need Tableau to do is ignore the Brands where Discount c = 0%. If you go to sheet 2 on the attached, you will see that only brand = "ter" has a discount not equal to 0%. So, in this case I would want the reference line to be shown at 14%.

      If I had two brands with, for example, 2% and 8% discounts and all others were 0%, I would want the reference line to be at 6%.

       

      I hope I'm being clear with my request.

      Thanks for your time!