This content has been marked as final. Show 2 replies
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!