Documentation

Dundas BI lets you apply formulas to data by writing small expressions much like you would in a spreadsheet program. This article describes different types of formulas and how to apply them.

This article lists the functions that are available for use in expressions entered into the formula bar.

Formula visualizations allow you to use data from one or more visualizations to produce a new metric set in a new visualization.

The Data Outlier functions identify the outliers in a set of input values.

The Rank function calculates the rank for each value in a set of input values.

The Distance function computes the as-the-crow-flies distance between a source and destination identified by latitude and longitude.

The Clustering function uses the K-Means algorithm to split data points into clusters based on similarity of the measures provided.

The Rank Value function returns the value found at the specified position, either starting from the highest or the lowest value.

The Average function computes the mean (or simple average) of a set of input values.

The Bollinger Bands functions are based on methods developed by John Bollinger. They compute a pair of data values based on the moving average of the input value series.

The Cumulative Total function computes the cumulative total (or running sum) of a set of input values.

The Exponential Moving Average function computes the average of a set of input values over a specified number of time periods.

The Historical Volatility function calculates the volatility of a set of input data values, such as stock prices over a period of time.

The Median function computes the median (e.g. middle) value from a set of input values.

The Mode function finds the value (or values) repeated more often than any other in a value series.

The Moving Average function computes the average of a set of input values over a specified number of time periods. The smaller the number of time periods, the faster the moving average responds to changes in the input values.

The Moving Average Envelopes functions compute a pair of data bands that envelop a moving average of the input data values.

The Percent of Total functions return the percentage of each value in the input series out of the total sum of the values in the input series.

The Sum function calculates the sum total for a set of input values.

The Trend and Forecasting function calculates a regression line or line of best fit. When applied to a time series, it can forecast future values.