Last Modified Date: 14 Apr 2017
- Tableau Desktop
AnswerCreate an IF/THEN logic calculated field that lists constants to use for each filter value that is contained within an ATTR() function to prevent automatic aggregation. The calculated field is then dragged out to details, and used for the reference line.
There is an attached .twbx which demonstrates this with Salesforce data, using Region as the filter, that includes a reference line that changes by region:
ATTR(IF [Region]="West" Then 2000
ELSEIF [Region]="East" Then 5000
ELSEIF [Region]="Central" Then 1000
ELSEIF [Region]="South" Then 3000
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials