how to hide results in dashboard when user number are small
I have a dashboard that contains some user information such as # of users, user activity(downloads, views etc), I have different filters set up to allow stakeholders to filter on user region, user group etc. However, due to the data privacy, I could not report on some info when # of user <20.
here is what I hope to do: when a stakeholders selects a filter(s), if it results the number of user <20, then all cards should not show anything or saying "data is not available to view".
Is there a way to do this?
Thank you for your help.
Best,
Olivia
Comments
-
Have you tried adding a filter in the analyzer of "# of users > 20"? This should keep those smaller ones from showing when other filters are applied.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@WizardOz - Are you wanting to allow the smaller groups if the total number of users is > 20?
One other thing of note you might want to keep in mind is to remove the drill path to the underlying data so that they can't see the small group of users. You'd also want to be careful with what's being graphed so the small user group information isn't showing when the user selects the table view instead of the graph view.
If you're wanting to allow the smaller groups if the total group population is > 20 then you could utilize a Beast Mode to calculate the correct display option and then use that field in your chart:
CASE WHEN SUM(`# Users`) > 20 THEN
SUM(`Views`)
ELSE
'Data is not able to view'
END**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive