how to hide results in dashboard when user number are small

Reply
Highlighted
Major Blue Belt

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

Highlighted
Red Belt

Re: how to hide results in dashboard when user number are small

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.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Highlighted
Purple Belt

Re: how to hide results in dashboard when user number are small

@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 the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!