Hi. I'm having some trouble updating the results of an experiment (query has been running for a few days now). It appears to be my ratio metric which didnt have issues updating a couple days ago. It seems like once my sample size goes over a certain number, the ratio metric will not update. The denominator part of the ratio metric runs fine when I run it separately, but, when I include the ratio metric, the results will not update. Would appreciate any guidance. Thank you.
06/23/2023, 7:56 PM
What datasource are you using? Is it timing out? Can you share the query with me in a DM? This could help me get you sorted.
06/26/2023, 6:49 PM
Hi, it was just stuck on "Running" for a few days, but I fixed this by creating a table in our DWH and doing a select * in GrowthBook. I think it was having trouble with the sql logic as there were a lot of joins on big tables.
06/26/2023, 6:50 PM
Yeah, the ratio metric queries can be pretty expensive. If there's a way to create smaller tables for those metrics to work with it may compute in a more timely fashion.