Loading

Conditionally Redacting Data

Udgivelsesdato: Apr 29, 2025
Opgave

How to conditionally redact data values based on response count thresholds in a crosstab?

 

For example, in survey data, certain question responses should be hidden (redacted) if the number of participants who answered that question is below a defined minimum—such as redacting results when fewer than 5 participants responded—to protect respondent anonymity and ensure data privacy.

Trin

The attached example workbook uses the sample data set Superstore to demonstrate redacting sales data for cities that have had fewer than 5 orders:

  1. 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
  2. Replace [Sales] in the view with [Sales with redactions].

Yderligere ressourcer
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.
Vidensartikelnummer

001458088

Vedhæftede filer

redacting data.twbx

1107 KB

 
Indlæser
Salesforce Help | Article