Creating Custom Time Tables

The first step in setting up a custom time hierarchy is to define a custom time table, usually in a spreadsheet. This table requires a column containing dates and other columns containing attributes of the dates.

For example:

  1. A table with a Date column called Fiscal Date and other attributes such as day/week/month names, IDs, and sequence numbers.
    Caution: 
    Include any period shift columns in the table.


  2. Load the custom time table into Birst using Quick File Upload.
  3. Enable the source.