How To Label Specific Points Above A Reference Line
28 Feb 2020
Last Modified Date:
28 Feb 2020
How to display label specific points above a reference line.
To show labels for specific points above the reference line for view like below where the reference line value is 50000:
1. Create a calculated field called
All points above reference line
with the following formula:
IF SUM([Sales])>50000 then SUM([Sales]) end
2. Create a calculated field called index with the following formula:
IF NOT ISNULL( [all points above reference line]) then
3. Create a calculated field called Rank with the following formula:
4. To show the first point above reference line, create a calculated field called F
with the following calculation:
If [rank]=1 then ([all points above reference line]) END
Did this article resolve the issue?
Thank you for providing your feedback on the effectiveness of the article.
Click here to return to our Support page.
Open new Case
Open a new case
Click here to go to our Support page.
Get detailed answers and how-to step-by-step instructions for your issues and technical questions.
Find and share solutions with our active community through forums, user groups and ideas.
Browse a complete list of product manuals and guides. Available online, offline and PDF formats.
Training and Tutorials
Learn how to master Tableau’s products with our on-demand, live or class room training.
PRINT THIS PAGE
SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
Download Tableau Desktop & Server
Tableau Online & Public Status
Send Large Files
All Tech Specs
Elite Account Management