Hello everyone.
I have a problem with metrics. I have two tables in bigQuery that they have one column in common.
I made a first metric a count type metric (
View Page Count
) and the second one count type (
Successful signups
) and I choose the first metric as
Denominator
for the second one.
Now the problem is however there are some data in there I can't see any data on the Experiment.
I wonder if I have to make the join table somewhere else or growthbook does this internally ?
yes they use the same identifier.
so with the first query I get total count of visits (type count ) and in second total count of success ( type Binomial )
I need to calculate the percentage of total success rate but when I choose the second metric as Binomial I can't choose Denominator any more.
user_id is the identifier for both.
How can I achieve the percentage of total success in general ?
Should I do it in one single query or connect them with Denominator ?
colossal-alligator-31194
08/16/2023, 10:50 AM
I just created a join table in Experiment Assignment Queries and seems I don't need Denominator anymore. I'm getting some numbers that seems correct.