https://www.growthbook.io/ logo
b

busy-judge-6469

06/27/2023, 1:46 PM
Hi, i think there was a recent release that is causing some issues to our count metrics. We want to count the average number of days a user is active after entering the experiment and the way we do it is by count(distinct date). We also have other count metrics that count(distinct id). They were working up until yesterday and it looks like the issue is the COALESCE part that did not exist before. Is there a way we can get this fixed?
f

future-teacher-7046

06/27/2023, 2:11 PM
Hi Sunil, we did release some SQL changes yesterday to improve performance and enable more advanced analyses. I'll check with the team to see how we can continue to support your use case.
b

busy-judge-6469

06/27/2023, 2:19 PM
thanks!
m

melodic-author-48337

06/27/2023, 7:32 PM
We saw this as well in some of our metrics. It looks like the ones we setup as booleans in the value column
f

future-teacher-7046

06/27/2023, 8:49 PM
@busy-judge-6469 @melodic-author-48337 We just pushed a fix for this. When you get a chance, can you refresh your results and see if it's fixed for you?
m

melodic-author-48337

06/27/2023, 8:59 PM
looks good on our end now!. Thanks for the quick fix
🙌 1
b

busy-judge-6469

06/28/2023, 6:56 AM
It is working now for me too. Thanks a lot!
🙌 1
2 Views