Hello! Is it possible somehow create relative metric? By saying "relative", I mean something like this: I want for example OTS (open-to-search) metric. Right now I have two binomial metrics - open and search (yes/no, number of users who opened something and then number of users who find something and it's all with me experiment feature) then divide them, and now I want to check this metric in my experiment; test group - 45% OTS and control 40% OTS (and its significant). I hope I was able to explain

have you looked at Activation metrics? We use them for a similar “people who do x given they have already done y” analysis as a custom report within the results of an experiment

Activation metrics can help for some scenarios. We're working on a more general approach on what we're calling "ratio" metrics where the denominator comes from another metric.

thanks guys. It worked for me in 95% cases.

Yes. If you look at the __experiment and __activationMetric selects, are they using user id or anonymous id?

sorry, I see now that I can change it in configure analysis. sorry again for taking up time. At the same time I'll try to understand, why script is running for 35 min. If I will see any issues I'll write you

What database are you using? If you don't have this already, we support some SQL placeholders in the experiment and metric queries that can help a lot to limit the amount of data scanned. https://docs.growthbook.io/app/metrics#sql-template-variables

I'm using BQ. But I don't understand how to use placeholders in experiments.

The placeholders don't work in the "custom SQL filter" setting. You can add them directly to the experiment query in the data source

but what if I have 1-year experiment?

can you send me the full sql that it's trying to run?

yes, DM