Hi team,
I have a data model where we keep track of the customers accounts as well as the campaigns created by them.
Customers have subscription_start_date and subscription_end_date as date dimensions
and
Campaigns have created_at as date dimensions
Further, Campaigns also have a Fact called as Volume
Subscriptions can run into multi years and the year (not the calendar year)Â of subscription starts from subscription_start_date
Eg.
A customer ABC, subscription_start_date = 04-Jul-2019, subscription_end_date= 04-Jul-2025
Current year volume would be sum of volume of all the campaigns created after 04-Jul-2022
Â
I want to create a metric that gives me the Volume for the current year of subscription
Â
There can be different customers with different subscription_start_date
Â
Best answer by Joseph Heun
View original