Function trend

trend( measure, name?, options?): CalculatedMeasure

Creates a calculated measure that computes a specified trend type for a given measure.

The trend types include linear (the default), logarithmic, advanced smoothing, and local estimates. You can also opt to automatically identify and ignore anomalous values in the series.

Trend requires a Sisense instance version of L2023.6.0 or greater.

Parameters

Parameter	Type	Description
`measure`	`Measure`	Measure to apply the trend logic to
`name`?	`string`	Name for the new measure
`options`?	`TrendFormulaOptions`	Trend options

Returns

CalculatedMeasure

A calculated measure instance

Example

Calculate the trend in total cost from the Sample Ecommerce data model.

measureFactory.trend(
  measureFactory.sum(DM.Commerce.Cost),
  'Total Cost Trend',
  {
    modelType: 'advancedSmoothing',
    ignoreAnomalies: true,
  }
)