If Count

[Nika3]

Hello!
I have a question: how does if request work with Count?
We need to limit our graph : hide sites that have less than 50 employees.
This formula seems to be correct, but still doesn't work.
If (Count ([Standort]) <50 , Null(), [Location (Submitter)]) .
We don't have unique field with number of employees , that's why need to make with Count( Standort) to have number of employees.
Is there a solution?
Thanks in advance!

[MatheusC · Accepted solution]

Hi, @Nika3 

I believe you are doing this from the frontend, so see if it works.

This will return the [Location (Sender)] only for [Standort] <50.

=aggr(

            if(

               if(Count(distinct [Standort]) < '50',1,0)=1,[Location (Submitter)]), [Location (Submitter)])

[MatheusC]

@Nika3 
Close the topic with the solution provided.

Thanks