daily avg users KPI based on a date

[1600eads]

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.

[marcus_sommer]

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))