I need to create a week-by-week report of a feature usage by customers similar to this: (ignore the numbers in the YTD column) [image] My dataset looks like this: (sample_date, customer_name, server_id, is_feature_enabled) where sample_date is a running date repleated daily even if there is no…

Here’s the solution I found - perhaps it would be helpful to somebody. I defined a calculated field feature user as ifelse({is_feature_enabled}=1, {customer_name}, NULL), and then the ytd field as periodToDateMaxOverTime(distinct_count({feature user}), {sample_day}, YEAR)

How to create a weekly YTD

Question & Answer

ErikG February 26, 2024, 6:26am 2

HI @kofmand
maybe you can have a look at:

1 Like