Being able to create Tables that compare WoW and MoM data showing the respective #, delta, and %

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

Users want to create Table Charts that display Week-over-Week (WoW) and Month-over-Month (MoM) comparisons for a given metric (e.g., sales) in Preset/Superset. The table should include the absolute value, delta (difference), and percentage change without requiring complex SQL workarounds.

How are they solving it currently?

Currently, users must manually compute these values in SQL using window functions (LAG()) and then create a Virtual Dataset. However, this approach:

• Requires SQL expertise, making it inaccessible to many users.

• Is cumbersome for those who frequently update or adjust their analyses.

• Cannot be easily replicated with built-in Table Charts, as they apply default aggregations that interfere with WoW/MoM calculations.

What is the recommended solution by the Customer?

Introduce a built-in option in Table Charts that allows users to add WoW and MoM comparisons without needing SQL.

Provide a Time Comparison Mode for Tables, similar to how Time Series charts handle comparisons.

Include formatting options to display absolute values, deltas, and percentage changes in separate columns.

Ensure these calculations work correctly when grouping by a dimension (e.g., product_line).