Hello,I have a question regarding the 'Daily Parti...
# give-feedback
f
Hello,I have a question regarding the 'Daily Participation' metrics in GrowthBook.After reviewing the raw SQL queries being executed against our database for specific A/B experiments, I believe the calculation logic might be incorrect. Specifically, I noticed that the query is missing a COUNT(DISTINCT DATE(timestamp)) — there is no DISTINCT operator used at all for the date.Is there someone I can discuss this with via private message? I can provide specific SQL examples and further details there.Best regards
l
@fresh-football-47124 @future-teacher-7046 Please pay attention to this issue. We use Daily Participation metric as a goal in half of experiments and we make decisions according to this metric.
f
Hi @freezing-kangaroo-80111 good morning 👋 Please can you DM over an example metric SQL and also the affected query SQL so we can further debug?
🙏 1
f
Hi @flaky-noon-11399! Are there any updates on this matter?
f
Hi @freezing-kangaroo-80111 not yet but will chase this up with the team today. We had our company offsite last week which has impacted response times. Should have a response on this shortly now that most of the team has returned to their home countries 🙏🏾
👍 1
Hi @freezing-kangaroo-80111 this is now resolved as per this PR. The changes would be live on cloud-hosted instances within 20 mins. If you're self-hosting you'll need to update to the latest tag. However, we have 4.4 being released next week with many great API features, incase you wanted to await that release to update once.
👍 1