Comparing Daily Averages Of Current Month/Quarter With Previous Month/Quarter
You might want to compare MoM on a daily average, which means to take the daily average of the current month (even if the month isn’t over yet), and compare it with the previous month’s daily average. You might also want to do the same for QoQ, meaning to compare the daily average of the current quarter vs. the previous quarter.
This solution requires either:
- An existing dimDates table we can add additional columns to,
-OR-
- Adding custom columns to your existing fact table to do the date manipulation required.
SOLUTION:
This is the end result that we’re aiming at:
MONTHLY LEVEL:
Formulas comprising this widget:
Filters:
Custom Formulas:
QUARTERLY LEVEL:
Formulas comprising this widget:
Filters:
Custom Formulas:
Updated 03-02-2023
