Tables and Pivot Tables

By default, when you are selecting a table it displays your data by time (usually by snapshot or load date)

However, if you click the option slider "Time Series" you can aggregate across your time series.

By default the time range is set to "Most Recent", which limits the dataset to the most recent load. However, you can also extend that range to a larger range of dates. This is generally most useful for non-snapshot datasets.

Pivot Tables

Once you have a dataset and a table, you can pivot the columns within that table. Clicking on the table bar to the right of your table opens the pivot options.

Clicking on the pivot mode slider allows two key changes:

  • Row grouping
  • Option for pivoting certain attributes onto columns

With row grouping, you can selectively expand individual items to progressively drill on them.

Dragging and dropping channel to the column labels drop area. Now, channel is pivoted onto the colums