Dynamic Chart Titles: Include Calculations, Variables, Field Choices

Omniscope chart titles now support dynamic components, allowing users to combine static text with formulas. This ensures that titles instantly reflect filtering and selections on the page.

What can be used inside a chart title, subtitle and footer:

Calculations – Include functions like Subsets to dynamically display sums, means, or other calculations.

Variables – Use exposed variables that report viewers can interact with on the tab.

Dynamic choices – Incorporate elements such as Grouping, Measure, or Field choices to adapt titles based on user input.

Below are some examples.

Formula calculating total capacity:

{{TEXTVALUE(SUBSET_SUM([Capacity_Mw]), "#,##0.00")}}

Variable name:

{{[My variable name here]}}

Tab name or number:

 {{[!tab]}}

{{[!tabNum]}}

Here we are adding dynamic Grouping breakdown to our Bar view, to show that the current Grouping choice is "Owner", followed by the word "breakdown":

{{[!grouping-choice:Grouping]}} breakdown

TIP:

The Content View Formula > Custom Formula Builder is a useful sandbox for designing and testing formulas. Once finalised, copy and paste the formula, surrounded by double curly brackets, into the chart title box.