Forum Discussion
Exclude cells with small sample sizes
Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.
Edit Interactions to Filter
You could create a simple COUNT measure and then add that to your report filter and set it to be >=5. If I understand the problem correctly.
I think a picture will help here (and perhaps a COUNT measure is appropriate). In the picture below, I have selected women who have a low sense of belonging on the bottom right graph, which then highlights those women across the other graphs. I really like this feature, but some of the sample sizes are too small to display. For example, the cell I have circled has fewer than 5 respondents and I would want to hide that from being displayed.
I began playing around with creating a COUNT measure and was not getting far with it. For the image below, there are 4 variables being used: Diverse, Belonging, Gender, and Race. Would I essentially have to build a long if/then logic calculation to use the COUNT measure?
I believe I duplicated this. I created the following data:
EthnicityCategory
Asian 1 Asian 1 Asian 1 Asian 1 Asian 1 Asian 2 Asian 2 Asian 2 Asian 2 Asian 2 Asian 3 Asian 3 Asian 3 Asian 3 Asian 3 Asian 4 Asian 4 Asian 5 Asian 5 Asian 5 Asian 5 Asian 5 Black 1 Black 1 Black 1 Black 1 Black 1 Black 2 Black 2 Black 3 Black 3 Black 3 Black 3 Black 3 Black 4 Black 4 Black 4 Black 4 Black 4 Black 5 Black 5 Black 5 Black 5 Black 5 I then put Ethnicity in my Axis, Category in my Label and then Count of Category (just changed the default summation from SUM to COUNT) in my Value. Then, in my filter area for the visual, I set "Count of Category" to "greater than or equal to 5"
Thanks for the help thus far. When I try this, the problem still exists because it doesn't seem to affect the highlighted numbers (see below). I got to this point by clicking on a bar segment from a belonging graph.
