min value different in kpi and table

[ioannagr]

Hi.

So I'm using the expression 

min(aggr(count (id), [associate_id]))

in two tables.

Table 1 has the associate ids and the expression next to it.   The totals set to min show the result "1".

When I use a Table 2 and I apply the exact same  expression alone, it returns that the min is "0".

The correct answer cross checked with SQL is "1". But how do I isolate that? 

What is happening? I was planning to use this min as a KPI.

[ioannagr]

AH yes i see it. Let's see now🙂

[ioannagr]

It's 1 now yay!!! thanks 😄

So with this you handled nulls ? What exactly does this expression you gave me mean?

I checked and there aren't null association_ids though in sql! 

[sunny_talwar]

I am not sure, but the nulls can be caused by joining in the scripts with other tables. but expression is just excluding any nulls in associate_id-id field while honoring the selection in associate_id-id field.

{<[associate_id] *= {"*"}>}