topic Re: If Count in Reporting Service & Alerting

If Count

Nika3 — Fri, 15 Nov 2024 21:17:58 GMT

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!

Re: If Count

MatheusC — Tue, 31 Oct 2023 17:13:28 GMT

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

Re: If Count

MatheusC — Fri, 03 Nov 2023 11:24:15 GMT

@Nika3
Close the topic with the solution provided.

Thanks