Hello,
I am working on a project that requires charts be hidden when <5 respondents are being queried (either from the base data or after filters have been applied). I have so far implemented a workaround using a scorecard that only appears and covers the charts when there are less than 5 distinct respondent IDs (conditional formatting). This works to hide the data, but even when the scorecard is "invisible" it still has to be ordered in front of the charts and prevents any hover-over/drill down data exploration in those charts.
I'm looking for a way to catch a N<5 input before it hits the charts, preventing them from being made. Conditional ordering? Filtering for distinct counts <5 and excluding? My issue with this solution is that I am displaying Likert responses out of 7 and that sort of filter will hide any distinct responses (1-7) with less than 5 responses but I need it to sum across the question as a whole for less than 5 total responses. Any help is greatly appreciated!
LinkedIn
Twitter
