I use several data sets in my analysis. Depending on several filters, one of the data sets is empty and the visuals based on this data sets show the message “No data. There was no data found for this visual”. This is all correct. But in that case, I simply want to hide the visuals.
I know how to hide this visual by default. I know that I need to create a rule depending on a parameter. But I don´t know how to set the parameter depending if the data set has data or not. It that possible? How would the solution look like?
Hi @Eva207 and welcome to the Quick Sight community!
While there’s no direct way to set the visual to hide just based on a ‘No Data’, there may be a way to build a work around like you are suggesting.
- What type of visual are you utilizing?
- How many/what fields are you using in the visual?
- What do you have setup (parameters, filters, etc.) that would cause the visual to show no data as opposed to showing data?
Hi,
the visuals I want to hide are of the type “vertical stacked bar chart”.
On the x-axis, I show dates ordered in calendar weeks.
On the y-axis, I show how often my dimension the chart is grouped by occurs. I only show one value. Each visual is grouped by another dimension.
The three visuals depend on one data set.
I apply to all three visuals the same filter. I filter for a time range and a unit name.
All data sets used in the analysis, contain the data field with the time range and the data field with the “unit name”.
But in my case for the filtered “unit name” no data is available.
To test how to create a rule to hide and unhide these graphics, I added a parameter “ShowGrafics” with the values “yes”, “no”, which could be set by the users manually and configured a rule. And it worked. But I want the parameter values set automatically to no, if for the chosen “unit name” the data set contains no data and to “yes” if data is available. Is there any workaround for that?
Hi @Eva207,
Thank you for the further clarification on your scenario. My thoughts were to setup an ifelse statement that sets a parameter value based on the value returned. That way if the value is zero or null, it will set the parameter as ‘hide’. But after testing out, it looks like current limitations within QS do not allow ifelse statements to set parameter values.
I’ve seen a couple other topics that discuss the desire for a feature that allows visuals to be hidden based on returning No Data, so I’ll mark this as a feature request to further promote the visibility of the request to the support team.
Thank you for the clarification!
So I guess, we need to wait until the feature request is available.