I have certain visuals that are supposed to remain empty, displaying rows only when data is available. Additionally, I need to send periodic reports. The issue is that the reports don’t get sent if there’s any empty visual. Is there a way to send the report even if the visual is null?
Hello @cosorio , welcome to the Quicksight community!
I’m not sure that this is possible, but you could try using the rules from the Free Form layout.
Hello @cosorio !
Were you able to try doing this using conditional rules in free form layout?
Hello @duncan, thanks for your response!
Yes, I could attempt using conditional rules, but this solution is quite manual. When this visual receives values, it is automatically assumed as an alarm. Introducing a control parameter for this scenario wouldn’t be meaningful, as users would have to manually toggle the parameter to check if there are values or not.
Hello @cosorio !
You could try creating an ifelse statement that would provide a message like “no data for this visual” when there are null values. That way when QuickSight sends the report you would sort of trick it to think that there is data.
I’m not sure how your data looks/is set up but you would do something like the following:
Ifelse({sales} = 0 or {sales} = NULL, "No data for this visual", {sales})
Let me know if this helps!