Dashboard View - Show If option?

[mykrobinson]

Is there a way to have one of the views in a Dashboard to not show if the view is empty? We have one hospital that our providers rarely round, and i'd like this view to simply not show up if no patients are slated for visitation there:

i don't see a "show_if" but am wanting to make sure i am not just missing a less than obvious option.

Thanks

[Suvrutt_Gurjar]

I think you may want to mention what is the type of the view and if the view is based on a slice or a table? It sounds in all probability the view should be based on a slice?

Presuming the view is based on a slice , please enter an expression

COUNT(Slice Name[Key Column])>0 

in the Show_if property of that single view.

If the view is based on a table name, please include the expression COUNT(Table Name[Key Column])>0 in the show_if property of the view.

[mykrobinson]

the view is based on slices, yes. I tried the Count expression and could not get it to work properly, likely due to there being spaces in the view name, but i could be wrong...

I tried playing with syntax and tried using quotation marks around the slice name, but it doesn't pass validation

[Suvrutt_Gurjar · Accepted solution]

Yes, please copy the slice name from the original slice name and paste in the expression.

[mykrobinson]

that worked, thank you. Didn't realize i was using the view name and not the slice name.

[Suvrutt_Gurjar]

You are welcome.