Hi @dsahu
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.