Looking (no pun intended) to figure out a way for a date ranger filter to only affect the numerator of a measure that divides two other measures?

[sten]

As of now the filter affects both the numerator and denominator when I apply the filter to the tile that has the conversion rate (trials / visitors) measure. But, I would like the date range filter to only affect the numerator of the conversion rate measure i.e. only affects the trials measure.

I tried setting up a filter in the view the dashboard is using i.e.

filter: in the view (programmatically)

and I tried using this filter within the sql of a new hidden measure for the numerator (trials) of the conversion rate measure (trials / visitors), but I didn’t know how to get this new filter to appear in the dashboard filter section / how to retrieve the date range from the filter dynamically when the user updates the date range filter.

Any help on how to achieve this functionality would be greatly appreciated!

[sarah_tayeri]

Hey Sten! I think this would be best accomplished via liquid, using a dynamic filtered measure. Then you could set the filter object to only apply to the numerator. We have some guidance about how to implement a dynamic filtered measure in our documentation here.