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!
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.