Count IF Division and Aggregate

[edugallowk]

Hello my friends!

I'm having difficulty constructing an expression, can you help me build it, both in the convetional method and in the set analysis?

I mounted the dimension this way and it worked:

DIM:

aggr(if(round(count(if(Events=1 or Events=11, Events))
/ 
count(distinct Date)) >=1,'Hiperconsultador',Null()), username)

Now I must use the same concept, however, to calculate the number of people who fall into this criterion.

I need to count the total number of users where the total of events dividing by total dates is equal to or greater than 1.

I thank the attention,

🙂

[Gabriel_Santos · Accepted solution]

num(
count(distinct if(aggr(
	(count(if([Events]=1 or [Events]=11, [Cod_Events]))
    /
    count(distinct [Date])) > 1
, username), username))
,'###.###')