|
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. |