Altair® Panopticon

 

Time Series Calculations

Calculated fields can be:

q  numeric columns or numeric time series

q  text time series

If one of the expressions used is a time series measure, then the result will be a new numeric time series calculated column.

As with standard calculated columns, time series calculated columns are calculated for every time slice and every item within the data set.

Example Numeric Calculations

Forecast Variance = ( [Actual] - [Forecast] ) / [Forecast]

Holding = [NumberofShares] * [LastPrice]

Example Text Time Series Calculation

time

anger

joy

sad

10/12/2020 00:00:00

20.00

100.00

0.00

10/12/2020 00:00:00

60.00

50.00

20.00

10/12/2020 00:00:00

80.00

10.00

30.00

10/12/2020 00:00:00

40.00

0.00

60.00

Sample fields

Transforming to enable time series, the time axis values will be based on the time column.

Sample expression for the calculated text column Dominant, calculates emotion with highest value at each time point:

IFTEXT(([anger] > [joy]) & ([anger] > [sad]), "Anger", IFTEXT([joy] > [sad], "Joy", "Sadness"))

 

NOTE

·          Text time series columns (calculated or not) cannot be used in the breakdown.

·          When the time series transform is switched off in time series calculation columns, an error message will be displayed “Can't use time series functions, the time series transform is not enabled.” Switch the time series transform on to fix the issue.