Hi
I want to get unique average users of each region .
I have used countd(user_id) but how to get average
have tried using LOD but not working as expected. Please guide
Thank you,
1 answer
Good morning @Jasmine Singha
Averages can be tricky so I always recommend calculating the numerator and denominator separately and then doing the division - see the use cases here https://jimdehner.com/2022/09/06/calculating-averages-or-rates-how-to/ on how to calculate the average or rates
