cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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:
Rate this article:
Version history
Last update:
‎03-02-2023 08:35 AM
Updated by:
Contributors