Support for Dynamic Variables (Totals, Deltas, etc.) in Alerts and Reports Content

What is the problem or goal the end user is trying to solve or accomplish?

Users want to include dynamic, data-driven values (e.g., totals, percentage changes, deltas) in the alert or report message body. This is critical for making notifications actionable without requiring recipients to open the attached chart or dashboard.

Example desired message:
"🚨 Total Sales reached $1.2M today, a 15% increase from yesterday."

How are they solving it currently?

The alert/report content in Superset and Preset currently only supports static text plus chart/table images.

Users must open the attached image or dashboard to see the actual values.

Advanced users sometimes work around this by sending alerts via webhook to custom processors that reformat the payload and inject dynamic values, but this requires external infrastructure and technical expertise.

What is the recommended solution by the Customer?

1. Enable template variables (e.g., Jinja or a Superset-specific syntax) in the Alerts & Reports message body.

2. Allow referencing metrics from the triggered chart/query, such as:

   • {{ latest_value }}

   • {{ delta_vs_previous }}

   • {{ percentage_change }}

3. Support basic formatting (e.g., rounding, percentage display).

This would allow meaningful, action-oriented alerts natively within Preset, reducing the need for external automation.