Multi-stage calculations

[igorlukanin]

Cube provides rich data modeling capabilities and supports various use cases.

We would like to level up Cube's data modeling with the post-aggregation engine that would allow for further manipulations with already aggregated data, supporting more sophisticated analytics use cases or providing a way to express them in the data model in a streamlined way:

• Period-to-date calculations, such as year-to-date (YTD), quarter-to-date (QTD), or month-to-date (MTD) analyses.
• Differences or changes: finding the difference between two aggregated measures, like year-over-year sales growth.
• Fixed vs. relative comparison, which are useful when you need to compare individual items to a broader dataset.
• Ratio and percent of total calculations, calculations of ratios or percent totals that need specific control over the numerator and the denominator.
• Segmentation and grouping, calculations of advanced segmentation or grouping that is independent of the view’s granularity.

It's currently planned for October 2024.

Out of scope:

• Pre-aggregation support in multi-stage calculations #8487