Hidden table visual

Q&A
, , ,
1

in my dashboard i have a hidden table visual, when a filter is clicked and no data is available, is it possible to make the table visual “no data available for this specific case”

image
image2607×833 37.7 KB

2

Hello @izzycs, the only visual that really allows for functionality like this is the insight visual. Inside of the content displayed, you can add ifelse statements and loops to check for whether or not data exists. As far as the tables go, there is no way to adjust the text displayed when the data is NULL, nor can you show or hide the visual since that is not something you can update a parameter value with.

5 Likes
3

Actually, one thing that could potentially work is, how are you controlling the visual that is being displayed? Maybe there is a way we can alter the parameter based action that controls whether or not the table shows to change the visual that displays when no data is available.

4 Likes
4

i am currently using a parameter filter control that is used at the top of the page

5

@izzycs if you were willing to do something a little different, I think we could make it work.

Instead of showing a dropdown filter, if you formatted a table to make it look like a selector where the user could adjust the parameter filter with a navigation action, then we could make this work.

You could create a 2nd calculated field that would check if the returned value was NULL or not. Something simple like this:

ifelse(isNull({Field}), 0, 1)

Add that as a hidden field in the table, then you can use the navigation action on the table that controls the parameterized filter, to also change a secondary parameter that will return the value from the calculated field. Then, you can check if that parameter equals 0, then display an insight visual over the table displaying the text you want the user to see.

It isn’t perfect because it will require you to change how the parameter control filter is displayed to the user, but it could be used as a potential work-around.

5 Likes
6

Hi @izzycs ,

Following up as it has been a while since last communication has taken place on this thread, was the solution provided above helpful for you in your scenario or did you have any additional questions?

If we do not hear back from you in the next three business days, I will go ahead and mark this as a solution.

Thank you.

7

Hi @izzycs ,

Since we have not heard back further on this thread, I’ll go ahead and mark this as solved. However, if you have any additional questions regarding your situation, feel free to create a new post in the community.

Thank you.