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