
1. Re: How to show lack of statistical base on survey data
Patrick A Van Der Hyde Apr 16, 2018 3:02 PM (in response to Luciana Junqueira)Hello Luciana
Is the indicator to appear regardless of which filter is selected or only based on the male/female filter? For example  in the example workbook included, the schooling was set to "High School" for Schooling and i wanted to verify because looking at this, I would think the only impacted column would be Concertos in the sample data.
Patrick

2. Re: How to show lack of statistical base on survey data
Luciana Junqueira Apr 19, 2018 12:50 PM (in response to Patrick A Van Der Hyde)Hello Patrick
Thank you for your interest and help.
The indicators should appear regardless of which filter is selected. We have 10 filters and we let the users decided which ones to use. If they select many filters the survey shows data that has lack of statistical base and then we need to make this very clear.Josh Davis helped us with a calculation using WINDOW_SUM to add together sums of values across parts of the view, so if they are <30 it will show the symbol.
I think this is a very important part of surveys so if Josh doesn't post it here I will place the workbook for further reference.
Luciana

3. Re: How to show lack of statistical base on survey data
Josh Davis Apr 19, 2018 3:55 PM (in response to Luciana Junqueira)1 of 1 people found this helpfulLuciana, I'm glad I could help!
I will let you post a workbook of your choosing since we keep the data you provide to us private
Although many calculation problems can be solved with either Table Calculations or Level of Detail Expressions, this question is a great example of something only Table Calculation functions can achieve: dynamically evaluating at a slightly broader granularity than the view.
If we needed to calculate across a specific dimension, we could use
{EXCLUDE [dimension to ignore]: SUM([measure])}
or
{FIXED [other], [dimensions], [in], [view]: SUM([measure])}
However, when the dimension to evaluate across changes, we need a Table Calculation.
Compute using Pane tells Tableau to evaluate the Table Calculation along the groupings of marks in the view, in the direction specified.
Pane (Across) groups all the marks within the secondtolast dimension on the Columns shelf, ignoring the last dimension on Columns.
Our article on Addressing & Partitioning contains further details on what is meant by a pane in the context of Table Calculations.
While we're on the topic of survey data, it's also worth taking a look at this whitepaper on Visualizing Survey Data
Thanks for sharing! Have a wonderful evening!

4. Re: How to show lack of statistical base on survey data
Luciana Junqueira Apr 19, 2018 4:33 PM (in response to Luciana Junqueira)Attach workbook with the solution.
Thanks, Josh Davis