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