MicroStrategy ONE

TrendV

The TrendV function uses data recorded for certain time intervals to calculate and display the expected value of data for an unknown time period. This is most commonly used to predict future metric values based on historical data. For example, based on revenue data for three years, you want to predict what your Revenue will be for the coming year.

You can use TrendV to predict values for any point in time, including dates that have known data. However, this type of function is meant for predicting future, unknown values.

This function uses a linear equation to predict future values. Therefore, it is best suited to predict values that are increasing or decreasing in a linear trend. For example, if your profits are increasing by $10,000 each year, this is a scenario that is well suited for a prediction based on a linear equation.

For a function that predicts values in a similar way for data that is increasing or decreasing exponentially, see GrowthV.

Syntax

TrendV <FactID, SortBy>(KnownData, FutureTimeOffset)

Where

  • KnownData is an object representing a list of values. This list of values is the known data to use to predict a future value for. KnownData is commonly used for metrics that represent data such as revenue, profit, and so on.

  • FutureTimeOffset is the point in time after the final time interval available for which to predict the data. This is commonly defined as an integer. For example, to predict values for the year 2029 when the last available data you have is for 2027, you would enter the value of 2 for FutureTimeOffset.

    The TrendV function assumes that data is available for sequential time intervals with no missing data. If your data meets these requirements, this allows you to use a single expression to use on reports with varying time intervals such as year, month, quarter, and so on. This is an advantage of TrendV in relation to ForecastV, which requires you to specify a time interval such as year for each expression.

  • FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.

  • SortBy is a parameter that defines the order of calculation. For more information, see SortBy.

For additional information on and an example of this function, refer to the MicroStrategy Functions Reference.