Support for Cumulative Calculations with Division Metrics (SUM(X)/SUM(Y)) in Charts

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

The user is trying to create a cumulative line chart where the metric is calculated as SUM(X)/SUM(Y) rather than summing individual percentages (SUM(X/Y)). This is crucial for ensuring accurate cumulative ratio calculations in dashboards that use dynamic filters like time grain.

How are they solving it currently?

Currently, the user has to use a workaround involving SQL queries, where they manually calculate cumulative sums for the numerator and denominator (X and Y) using window functions, and then divide the cumulative results. This approach is complex and limited when COUNT(DISTINCT) aggregations are involved.

What is the recommended solution by the Customer?

The customer is requesting a feature that directly supports cumulative ratio calculations in metrics (SUM(X)/SUM(Y)) within the chart builder, allowing for accurate cumulative results even when dynamic filters and time grains are applied, without needing complex SQL queries.