I’m building a Looker Studio dashboard to visualize data from a team health survey, with the raw data stored in Google Sheets. The dashboard is intended for leaders and managers to explore trends and drive action.
To protect anonymity, I only want data to be displayed when there are 3 or more responses in a given slice. This filter should also respect user-selected controls at the top of the report (e.g., team, location, role).
Is there a way to dynamically suppress or hide charts/tables unless the filtered result set has 3+ rows? Ideally, if the result set is too small, the component display a message like “Not enough data to display.”
Would love any suggestions or best practices on how to implement this!
Thanks!