How to Schedule Snapshot Report Only If Data Is Present

Q&A
, ,
1

Hi all, I’m trying to schedule a snapshot (via email) of a Quick Sight dashboard to users, but I only want it to send if there is data present. If the dataset is empty (for example, no records for the day), I would prefer not to send the report at all.

Is there any way to add a condition to the scheduled report so that it only triggers when data is available?

If that’s not possible, is there a workaround using alerts that allows me to send a notification to multiple users when certain conditions are met?

Thank you!

2

Hi @Kalyan_reddy

Please try scheduling email reports and configuring threshold-based email alerts.

Example: Add a KPI visual to your analysis that shows the row count (or another measure) for your daily dataset. Then create a threshold alert on that visual with the condition count > 0 and add all your Quick Sight users (or groups) as subscribers.

3

@Xclipse I already tried creating a KPI visual setting up an alert when the count > 0. However, I’m Unable to Add Other Users:
I cannot see any option to add other users or groups. Please see the screenshot below.

image
image170×436 15.8 KB

Also “View Dashboard” Button Not Working:
I tested the alert by sending it to myself. While I received the email, the “View Dashboard” button doesn’t work. It doesn’t open the dashboard when clicked. I’ve attached a screenshot of this as well.

image
image772×431 32 KB

Thank you!

4

@Xclipse I wanted to explain my use case and check if there’s a way to automate this in Quick Sight.

For e.g., I have a list of students and their scores. I need to send a report only when students have scored more than 30 marks. The idea is to send this report daily, but only if there are any such students on that day.

So essentially:

  • If at least one student scores > 30, send a report listing those students.
  • If no student meets the threshold, do not send the report.

Can this be done through scheduled reports or alerts in Quick Sight? Thank you!

5

Hi @Kalyan_reddy

At present, I believe scheduled reports can be delivered to users and groups based on a set schedule. I understand that threshold alerts send emails only to the owner who set the alert. There is no option to send an email based on a trigger, and you cannot customize alert emails for multiple user groups.

I have marked this topic as a feature request. Feel free to let me know if you have any follow-up questions otherwise, I will archive this topic.