Schedule a conditional export or alert

You can schedule an export to send only if specific conditions are met, functioning as a conditional alert. Trigger an export based on whether data is available, or on the specific value of a control or column. This flexibility lets you fine tune recurring exports and ensure efficiency and relevance of the exported reports.

For example, configure a conditional alert to support outlier and anomaly detection workflows, sending a Slack notification when data in a specific column is above a specific value, or matches a specific anomalous condition.

This document explains how to schedule a recurring export with a predefined condition.

User requirements

To add conditions to scheduled exports, you must be assigned an account type with the Schedule exports permission enabled.

📘

Additional requirements might apply depending on the export destination.

About conditional exports and alerts

A predefined data condition acts as a filter to determine whether Sigma initiates a scheduled export. When an export is due, Sigma checks the data and only proceeds if the condition is met. The recurring schedule ensures that an export is timely, while the condition ensures it is relevant.

🚧

When executing a scheduled export or direct download to PDF or PNG formats, Sigma may store applicable control values as URL parameters in trace logs used for debugging and troubleshooting purposes. Exercise caution when exporting or downloading workbook content that uses controls to filter sensitive data.

Schedule an export based on data availability

Schedule a recurring export that only initiates when a specific data element or input table meets a predefined data condition.

1. In a workbook header, click the caret () associated with the workbook's name and select Schedule exports....

2. If this is the first schedule for the workbook, click Add Schedule, otherwise click + New schedule.

3. In the Frequency section, for Send, select If a condition is met.

4. (Optional) If you choose to send an export only If a condition is met, you can turn on the switch to stop notifying after a set number of occurrences per day, week, or in total. (This feature is in beta and subject to the Beta features notice).

5. In the Condition section, specify the condition settings:

   1. For Send, specify the condition under which to send the export:

      • If there's no data: Export as scheduled if there is no data available in the target element.
      • If there's data: Export as scheduled if data is available in the target element.

   2. For In data element, select the target element to which the data availability applies.

      📘

      Although the condition applies to a single target element, you can configure the schedule to export the entire workbook, specific pages, and individual elements.

   3. Click Test Condition to check if the target element currently meets the condition. If the results don’t align with your expectations, confirm that you selected the correct condition and target element.

   

6. Complete the remaining sections in the Schedule Exports modal. For more information, see the following documentation based on the preferred export destination.

   📘

   Destination availability depends on account type permissions.

   • Export to email
   • Export to Slack
   • Export to Google Sheets
   • Export to Google Drive
   • Export to webhook
   • Export to cloud storage
   • Export as email burst

7. Click Create to save the configured schedule.

Schedule an export based on a conditional statement

Schedule a recurring export that only initiates when a specific data element or input table satisfies a predefined conditional statement.

1. In the workbook header, click the caret () associated with the workbook's name and select Schedule exports....

2. If this is the first schedule for the workbook, click Add Schedule, otherwise click + New schedule.

3. In the Frequency section, for Send, select If a condition is met.

4. (Optional) If you choose to send an export only If a condition is met, you can turn on the switch to stop notifying after a set number of occurrences per day, week, or in total. (This feature is in beta and subject to the Beta features notice).

5. In the Condition section, specify the condition settings:

   1. For Send, select If a condition is met to export as scheduled if a specific data condition in the target element is met.

   2. For In data element, select the target element to which the condition applies.

      📘

      Although the condition applies to a single target element, you can configure the schedule to export the entire workbook, specific pages, and individual elements.

   3. Define the conditional statement. For Check if, select which element values to apply the condition to:

      • Any value: The condition must match for one or more values in the column.
      • All values: The condition must match for all values in the column.

      If the selected element is a KPI, you can check additional conditions:

      • {Element title}: One or more values in the element's Value property column must meet the criteria.
      • Comparison value (%): One or more values in the element's Comparison property column must meet the criteria.

   4. If you selected Any value or All values, for In column, specify the column to be used.

   5. For Is, select a comparison operator.

   6. For Value, select a comparison value.

   7. Click Test Condition to check if the target element currently meets the condition. If the results don’t align with your expectations, confirm that you selected the correct condition and target element.
      

6. Complete the remaining sections in the Schedule Exports modal. For more information, see the following documentation based on the preferred export destination:

   📘

   Destination availability depends on your account type permissions.

   • Export to email
   • Export to Slack
   • Export to Google Sheets
   • Export to Google Drive
   • Export to webhook
   • Export to cloud storage
   • Export as email burst

7. Click Create to save the configured schedule.

Schedule a conditional alert for an element

To monitor a specific data element or input table, schedule a recurring export as a conditional alert, such as an email or Slack message.

💡

You can create a conditional alert using the steps in the previous sections of this document, this method auto-populates specific fields to make it easier to quickly configure a conditional alert.

1. In the element toolbar, click More to open the element menu, then select Alert when.

   📘

   You can only create alerts for published content. If the target element hasn’t been published or contains unpublished changes, Sigma prompts you to publish the workbook.

   

2. In the Schedule Exports modal, configure the alert. Sigma configures a default conditional statement in the Condition section (based on the type of target element), auto-populates the target element’s title as an email Subject or Slack Message, and selects the target element in the Attachments field.

   1. Customize fields as desired, then complete the remaining sections. For more information, see Schedule an export based on data availability and Schedule an export based on a conditional statement in this document.

   2. Click Create to save the schedule configurations.