You can add multiple schedules with different configurations for a single Liveboard. However, each job is limited to one Liveboard schedule. To add or modify a schedule, you must either be an administrator or have the schedule Liveboard privilege, and at least edit-only and view-only access to the Liveboard.
To schedule a Liveboard:
- Sign in to ThoughtSpot from a browser.
-
Select Liveboards, on the top navigation bar.
- Select the Liveboard you want to create a schedule for.
-
Click the ellipses icon and select Manage schedules to view all of the schedules set for the Liveboard.
-
Click + Schedule to add a new schedule. To modify a schedule, click on the schedule you would like to edit.
-
Set the values for your schedule.
Field Description Repeats You can rebuild a Liveboard every n minutes, hourly, daily, weekly, or monthly. For some of these, you can also choose specific times of the day or days of the week. Make sure to note the Server time zone which is the timezone which will be used. Name Provide a short name for this schedule. Description Enter a description to remind yourself and to inform others. For example, if this is an important schedule for a meeting or a report, you should mention that. Type CSV files provide all data for tables, with one attachment per table. Use CSV files to perform further analysis offline. PDF files show all visualizations in the Liveboard. Each chart takes up a whole page in the file, while only the first 100 rows of a table are included. Use PDF files to skim the data. Gating condition Write a statement that returns a single boolean value (true or false). For example,
sum (revenue) > 100
is a valid condition butis_weekend (commit_date)
is not. You can use any valid formula in your statement. Other than checking your formula syntax, ThoughtSpot does not validate your formula returns a single boolean.At the scheduled time, ThoughtSpot checks the gating condition, and, if the condition returns true, processes the Liveboard. For a list of valid formulas, see the Formula function reference.
For an in-depth example of a scenario where a gating condition is useful and powerful, refer to Liveboard schedule gating conditions in practice.
ThoughtSpot executes the gating condition as a ThoughtSpot admin user. If you are using passthrough security for your external data warehouse connection, the gating condition may not work.
Embedded link format If your ThoughtSpot environment is embedded, select Embedded link format to generate a URL for your host application context. This option allows you to ensure that the links to the object in email notifications go to the appropriate application URL. Recipients You are limited to 1000 recipients per job. You can add Users or groups to enter ThoughtSpot users or groups. Use Emails to add recipients that are not ThoughtSpot users. Any users your ThoughtSpot admin must have set your whitelist domains. Contact ThoughtSpot Support to set your whitelist domains.
If you experience problems with sending email, your cluster may not have SMTP enabled. Contact your system administrator to resolve this issue.
- Click Schedule to save your new schedule, or Save to save your modified schedule.
When you download tables with date columns or view these tables in scheduled Liveboards, the format for those dates may differ from their appearance in ThoughtSpot. The following date bucketing types may look different:
Bucketing Type | Appearance in ThoughtSpot | Appearance in CSV, XLSX, or PDF |
---|---|---|
Hourly | AM/ PM | 24 hour |
Day of week | Name of day (for example, Saturday) | Number of day (for example, 6)1 |
Monthly | January 2021 | 1/1/2021 |
Month of year | Name of month | Number of month2 |
Quarterly | Q1 2021 | 1/1/2021 |
Quarter of year | Name of quarter (for example, Q4) | Number of quarter (for example, 4) |
Yearly | 2021 | 1/1/2021 |
Table notes:
|