Last Modified Date: 17 Jan 2019
AnswerBuild the behavior using Level-of-Detail expressions and Action filters:
- Use a FIXED Level of Detail expression in Calculated Field to return the denominator of a ratio that return a percentage (so the value will not be affected by standard dimension filters). For more information about FIXED expressions, see FIXED Level of Detail Expressions in Tableau Help.
- Use an action filter to filter the numerator of the calculated percentage. For more information about Action filters, see Filter Action in Tableau Help.
Additional InformationFor more information, see section 14 of the "Top-15 LOD Expressions" blog post.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials