Table

The table format is useful where your values don't vary over time, i.e. it is more of a static database of information.

The table format consists of:

• The top row represents the dimension name or variable name
• Each row below the top row represents a single dimension item
• The first column must contain the primary dimension. Additional columns will contain mapped dimensions, unmapped dimensions, or variables:

1. Mapped Dimensions: The first row must have the name of the dimension being mapped from and the name of the dimension being mapped to, in the following format: [from dimension] > [to dimension]
   • The arrow (">") is important - it's how Causal distinguishes between a normal dimension column, and a dimension mapping column! This is equivalent to linking dimensions in Causal, except that you cannot modify the link from within Causal in this case.
   • Each row contains the "mapped" dimension
2. Unmapped Dimensions: The first row will contain the name of the dimension and each row contains a dimension item.
   • It is rare that you will use unmapped -- or nested -- dimensions in the table format
3. Variables: The first row will contain the name of the variable and all subsequent rows will contain the values, whether it's a date or a number, for the associated dimension item.
   • You do not need to include a > in a variable column!

In our example snip above:

• Name is the primary dimension
• Each name is mapped to a team dimension, which is why the format name > team is used, and the rows show how the Name maps to a Team, e.g. Kevin is in the Engineering team
• start date [date], salary, and bonus are all variables, so they don't need a >