Question
How to conditionally redact data values.For instance, responses to a survey question may need to be redacted if fewer than a threshold number of participants answered the question.
Last Modified Date: 18 May 2017
For instance, responses to a survey question may need to be redacted if fewer than a threshold number of participants answered the question.
Environment
Tableau DesktopAnswer
The attached example workbook uses the sample data set Superstore to demonstrate redacting sales data for cities that have had fewer than 5 orders:- Create a calculated field, name it "Sales with redactions" and enter a formula similar to:
IF COUNTD( [Orders ID] ) > 5
THEN SUM( [Sales] )
ELSE NULL END - Replace [Sales] in the view with [Sales with redactions].
Additional Information
The ELSE NULL statement will show blank cells in a crosstab view for redacted data. ELSE NULL can be replaced with ELSE 0 to show zeros in the view. NULL values can also be aliased to show a text value.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials