Hi Team,
I am trying to display when there is no data availabe then display “No Data available on Selected Date”
I have tried to use Insight visual and use Customize narrative
Added computation
Selected Unique Values = if UniqueGroupValues.uniqueGroupValuesCount =0
(No Data Available on Selected Date )
And applied the filter into this Insight visual.
This is working fine the problem is when there is a data then the insight visual is overlapping with existing visual how can we make disable this insight visual if data exists.
Thanks
Syed
Hello @Alam_Syed, so in order to show or hide the insight, you would have to do it based on a certain parameter value through conditional rules.
Here is documentation on applying conditional rules in QuickSight.
The difficult part of this is it would require you to know a filter value that would cause the no data error to occur. You have to set a specific parameter value that would cause the visual to appear or disappear.
Alternatively, you could include a button or a control that could allow the user to toggle the insight on and off. I usually create a table that only uses 2 calculated fields. One that will say something like “Toggle Message” and then another that checks if no data is available return 1, else 0. You can hide that calculated field from the display and then set the parameter value with a navigation action on click based on the user selection.
This solution was built for a different question, but it displays what I am suggesting about the button. Refresh Data Button
The parameter you set with that button would then be used in the conditional rules for the insight visual. Let me know if this helps!
Hi @DylanM thanks for the replay.
I have also tried this Rules conditions based, the problem is when we use this rules condition here also the default text message shows..
1 Like
Hello @Alam_Syed, unfortunately I think there is a limitation here. There isn’t a way to programmatically update a parameter value based on the availability of data. The parameter to handle conditional rules needs to be updated through some type of control or action completed by the user.
Unless you would embed the filtering capabilities in an application that is hosting the dashboard, and you had a way to confirm with the data that a selection is going to return no data, I think you will be blocked. This type of functionality just isn’t present directly within the QuickSight console at the moment.
I can tag this topic as a feature request since there isn’t a current solution available. Please let me know if you have any further questions, otherwise I can archive this topic for our Support Team. Thank you!
1 Like
Hi @DylanM , Yeah Sure thank you for the update..
1 Like