Forum Discussion
Helper IHide data in visualization if too few responses
Super UserHi,
In the Visual level filters section of the visualisation pane, apply a filter on the measure of >3.
Hope this helps.
maronisThanks for the response! So I did think of that - the issue is that because of the way the data is structured, here's what would happen if I applied a filter like that -
Say there was a business unit with four responses, three are 'agree' and one is 'disagree.' If I apply a filter like what you suggest, what would appear in the visualization is a chart that shows three 'agree' responses, but no 'disagree' responses.
Similarly, if there were a business unit with three responses, two of which are 'agree' and one 'disagree' the filter you suggest would return no results at all, when in fact I do want to show results for that business unit because there are three responses in total.
Any other ideas given the clarification above? Thanks again!
- Ashish_Mathur
Hi,
So then we cannot look at absolute numbers at all - your premise of 3 will not be valid in that case. We must then compute the numbers of respondent/Total population for that group and filter based on that.
- maronis
Thanks - is there an easy way to do that? I was trying to think of constructing a measure that would count the total number of respondants and filter based on that but I can't for the life of me think of how I'd construct that.