To GoodData homepage

Topics started by deedeedudu

1 Topic

deedeedudu
deedeeduduNew Participant
asked in Metrics and MAQL

Sum by current year of subscription rather than calendar year

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 dimensionsandCampaigns have created_at as date dimensionsFurther, Campaigns also have a Fact called as VolumeSubscriptions can run into multi years and the year (not the calendar year) of subscription starts from subscription_start_dateEg.A customer ABC, subscription_start_date = 04-Jul-2019, subscription_end_date= 04-Jul-2025Current 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 

3
Joseph Heun
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings