CODEWITHSUNDEEP
dynamictableau-apiprivacy
schradera
schradera

Reputation: 115

Tableau: How to hide cell values when less than 5

I use tableau at work to work with various data types, including sensitive personal data that should only be shared in an aggregated format. I am trying to find a way to protect private information by hiding the cell value when it is less than 5. This way when users drill down they don't actually drill down to an individual person or small group that could be identified.

I know some people have used window_max to restrict the total number of records, but this is not suitable for my purposes as I need to restrict values on the cell level. Because the categories are unevenly distributed, there could be a large number of records and still a combination in the table small enough to disclose privileged data.

For what it is worth, I am using multiple measures and can't just filter on number of records.

Upvotes: 3

Views: 7397

Answers (3)

Alex Blakemore
Alex Blakemore

Reputation: 11921

Bethany Lyons gave a useful presentation about using Sets with Tableau, and covered a similar use case about halfway through.

Her solution is a bit different than the other answers, showing anonymous detail when there are a large number of individuals in a group, and just an aggregate value when there are a small number of individuals (to protect anonymity)

The link to the archived video can be found within this thread https://community.tableau.com/thread/151806

Upvotes: 0

schradera
schradera

Reputation: 115

The credit for this actually goes to Simon Runc over at the Tableau Forums. Since my table uses multiple measures you can't filter on "number of records" like you could if it were only one measure. The trick he suggested was to create new calculated fields for each one using IIF statements, then use those as my multiple measures. You can see what he did, with workbook, at https://community.tableau.com/message/535021#535021.

The actual code for the calculated field is

IIF(SUM([Rating 15 - 19])>=5, SUM([Rating 15 - 19]), NULL)

Where [Rating 15-19] is one of my original measures. You would have to repeat this for each one then use them all together.

Thank you to @woodhead92 who was headed in the right direction but didn't have the benefit of a sample workbook to see I was using multiple measures at once.

Upvotes: 2

woodhead92
woodhead92

Reputation: 127

There is a measure called 'Number of Records' which can be used for this purpose. To filter your dashboard down, use the following filter

SUM(Number of Records) < 5

Upvotes: 0

Related Questions