I am working on quicksight currently for tagging data products on dependent file receipts. Wanted to ask, if we can create alerts based on particular files on a table if I want to set an alert for an individual file in this table.
For example, I want to see, everyday, if we missed Air Tahiti Nui(first file) or not. If the file is missed, we will get an email alert at a specific time that, today, we have missed the air tahiti nui file an the person can click on the view dashboard in the email, to come to this analysis /dashboard page for deep diving.
You can configure alerts to monitor specific conditions, including triggering an email when a particular file in a table meets the specified condition.
Create a calculated field in your dataset that checks if the specific file (e.g., “Air Tahiti Nui”) is present in the table. For example, the calculated field might return a value like 1 if the file is present and 0 if not.
Ccreate an alert based on the KPI or table visual. Set the condition so that the alert triggers when the value indicates that the file is missing. When the condition for the alert is met (e.g., the file is missing), you will send an email notification to the specified recipients.
By setting up a calculated field and a corresponding KPI or table visual with an alert condition, you can monitor the presence of a specific file (like “Air Tahiti Nui”). If the file is missing, an email alert will be sent, and users can directly access the dashboard from the email to investigate further.
Please refer the below threshold alerts QuickSight documentation and blog this might be helpful for you.
Hi @dsahu,
Since we haven’t heard back, I’ll go ahead and close out this topic. If you have any further questions, feel free to create a new topic in the community and link this discussion for relevant information that may be needed.
