Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying grab the daily average user.
I am able to do this by a simple expression - =avg(aggr(avg( USER_ID), SNAPSHOT_DATE))
But now, I want to incorporate a set analysis or a condition to grab these users from different countries
e.g. =avg(aggr(avg({<COUNTRY ={'JAPAN'} >}USER_ID), SNAPSHOT_DATE))
but am getting a very high number that is incorrect. Any guidance/feedback will be helpful. Thank you.
You may need to add the condition to each aggregation-part of the calculation, which may look like:
avg({ Set } aggr({ Set } avg( { Set } Field), Dim))