Documentation

Using Calculations
-
Integrations
-

Send or Schedule Reports

With Sigma, you can set up a schedule to email you and your coworkers reports, post to a public Slack channel, or export the data to a Google Sheet.

Schedule a Worksheet Email Report

  1. Open up the worksheet you would like to set up a scheduled email for.
  2. Click the ‘…’ on the top right of the screen.
  3. Click on 'Schedule'.
  4. Click 'Add Schedule'
  5. Choose the frequency and time of day to send the emails, and who to send the emails to.
  6. Choose whether to run the queries for the schedule as the recipient. When this option is chosen, the scheduled reports can only be sent to Sigma users, and the user will only see the data they have access to in Sigma.
  7. Click ‘Save’.

Schedule a Dashboard Email Report

  1. Click the ‘…’ on the top right of the screen.
    If you can edit the dashboard, then you'll click the down arrow next to the Edit button.
  2. Click on 'Schedule'.
  3. Click 'Add Schedule'.
  4. Choose the frequency and time of day to send the emails, and who to send the emails to.
  5. Choose whether to run the queries for the schedule as the recipient. When this option is chosen, the scheduled reports can only be sent to Sigma users, and the user will only see the data they have access to in Sigma. Choosing this option will maintain any row-level security that you have set up for the dashboard.
  6. Click ‘Save’.

Edit a Report Schedule

  1. Click the ‘…’ on the top right of the screen.
  2. Click on 'Schedule'.
  3. Click the '...' to the right of the schedule you would like to edit.
  4. Click 'Delete' to delete the schedule, and click 'Edit' to make changes to the schedule.

<h3><span id="cron" style="font-weight:bold; padding-top: 100px; margin-top: -100px;">Set up a Custom Delivery Schedule</span></ h3>

If Sigma's default delivery options do not work for your needs, you can set up a custom cron for delivery time. To enter in the custom cron, specify the minute, hour, day (month), month and day (week). You can use this tool to help you write the correct cron expression.

To send a report at 1:05 AM on the first Monday of the quarter, you'd enter:

5 1 * 1/3 Mon

To send a report at 1:30 AM on the first of every month, you'd enter:

30 1 1 * *