[]
(Showing Draft Content)

Quick Functions

Quick Functions

Quick Functions are prebuilt calculations that transform the values displayed in a chart. Rather than showing only the original measure, Quick Functions allow you to calculate rankings, percentiles, running totals, moving averages, historical comparisons, and other derived values directly within the visualization.

Quick Functions are useful when you want to analyze trends, compare relative performance, identify patterns, or evaluate how values change over time. They make it possible to perform common analytical calculations without changing the underlying dataset or creating additional calculated fields in the data model.

Applying a Quick Function changes how the chart is interpreted. Depending on the selected function, the value axis may display rankings, cumulative totals, rolling averages, previous values, or changes between time periods rather than the original numeric measure.

Before applying any Quick Function, you must first access them from the chart’s data binding configuration. Select the chart, open the Data Binding panel, and locate the data attribute bound to the Values data binding slot. Click the gear icon next to the attribute to open the configuration menu. From there, hover over Quick Functions to reveal the available calculations, and then select the desired function. This entry point is consistent across all Quick Functions.

The following Quick Functions are available for most chart scenarios:

  • Ranking Calculation transforms values into their ranked positions within the dataset or within specific groups.

  • Percentile Calculation shows the relative standing of each value within the dataset as a percentile.

  • Running Calculation progressively accumulates or recalculates values across a sequence, such as a running total or running average.

  • Moving Calculation applies a rolling calculation across a range of neighboring values, such as a moving average or moving maximum.

Some Quick Functions are only available when a date attribute is bound to the Axis (Category) data binding slot. They can also be used when a date attribute is bound to the Legend (Series) data binding slot, although that scenario is typically more advanced because the time comparison is performed within each series.

These date-based Quick Functions include: