Update a custom calendar

After you create a custom calendar, you can update it the following ways:

  • Replace it with a completely new calendar you create in the ThoughtSpot UI.

  • Upload a comma, pipe, semicolon, or tab-delimited calendar file.

  • Create a new calendar from an Existing Table that you specify.

Examples of things you can change:

  • Language used for days of the week, and month

  • Quarter and fiscal year name prefixes

  • Starting date of the year

  • Starting dates of quarters

  • Starting day of the month

  • Starting day of the week

  • Separator used in the calendar

Replacing a custom calendar

To replace your custom calendar, do the following:

  1. Select Data in the top navigation bar.

    The Data workspace appears.

  2. Click Utilities in the side navigation bar, and select Add/modify custom calendar.

    The Custom calendar page appears.

  3. On the Custom calendar page, open the More menu more options menu icon next to the custom calendar you want to update, and select Update Calendar.

  4. For Database, open the Choose a database menu, and select the database you want to use with your updated custom calendar.

  5. For Schema, open the Choose a schema menu, and select the schema you want to use with your updated custom calendar.

  6. Select Replace.

  7. For Table, enter a name for the table that will be created for your custom calendar.

  8. For Start Date, enter the date you want your custom calendar to start.

    Both Start Date and End Date must be in MM/DD/YYYY format.
  9. For End Date, enter the date you want your custom calendar to end.

  10. For Calendar Type, open the Choose a calendar type menu, and select the type of calendar you want to create. Possible types include:

    • MONTH_OFFSET

    • FOUR_FOUR_FIVE

    • FOUR_FIVE_FOUR

    • FIVE_FOUR_FOUR

  11. For Monthly offset, open the menu and select a month.

  12. For Start day of week, open the menu and select a day.

  13. For Quarter name prefix, enter the prefix you’d like to use for quarter numbers.

    Example: Q

  14. For Year name prefix, enter the prefix you’d like to use for years.

    Example: FY

  15. Select Create.

    The Custom calendar page appears again, with the message "Custom calendar created successfully!"

Uploading a custom calendar

You can replace a custom calendar by uploading a calendar file in one of the following formats:

  • Comma-separated

  • Pipe-separated

  • Tab-separated

  • Semicolon-separated

Updating the calendar file

The easiest way to update a calendar file is to download an existing one, make changes to it, and then upload it.

To update your calendar file, do the following:

  1. Select Data in the top navigation bar.

    The Data workspace appears.

  2. Click Utilities in the side navigation bar, and select Add/modify custom calendar.

    The Custom calendar page appears.

  3. Open the More menu more options menu icon next to the custom calendar you want to update, and select Download as CSV.

  4. Open the file in a text editor, and remove the first 3 lines (which contain metadata).

  5. Make any other changes required, and save the file with a new name.

    You must save the updated file with a new name, or you will not be able to update the calendar.
  6. Go to the next section to upload your calendar file.

Uploading your calendar file

To upload your new or updated calendar file, do the following:

  1. On the Custom calendar page, open the More menu more options menu icon next to the custom calendar you want to update, and select Update Calendar.

  2. For Database, open the Choose a database menu, and select the database you want to use with your updated custom calendar.

  3. For Schema, open the Choose a schema menu, and select the schema you want to use with your updated custom calendar.

  4. Select Upload File.

  5. Select Upload, choose the file, and upload it.

  6. For Separator, select the separator used in the updated calendar you are going to upload.

    Options include Comma ( , ), Pipe ( | ), Semicolon ( ; ), and Tab.

  7. Select Update.

    The Custom calendar page appears again, with the message "Custom calendar created successfully!"

Create a new calendar from an existing table

To create a new calendar from an existing table, do the following:

  1. On the Custom calendar page, open the More menu more options menu icon next to the custom calendar you want to update, and select Update Calendar.

  2. For Database, open the Choose a database menu, and select the database you want to use with your updated custom calendar.

  3. For Schema, open the Choose a schema menu, and select the schema you want to use with your updated custom calendar.

  4. Select Existing Table.

  5. For Table, select an external table to use for creating your custom calendar.

  6. Select Create.

    The Custom calendar page appears again, with the message "Custom calendar created successfully!"