Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Okay the result is blank. No zeros , no "-", no nulls, nothing.
Not sure what might be going on... one last question... is id and associate_id coming from the same table or different table?
Yes both from the same table. 😐
I have one question for you too, what did you mean by suppressing dimension?
Maybe this is the last resort for me checking.
This just means that are there any nulls in associate ids? I mean one way to remove null associate ids would be to use this expression
Min({<[associate_id] *= {"*"}>} Aggr(Count(id), [associate_id]))
One beautiful blank screen appeared. 🤔
Can you post a screenshot?
Yes here it is.
Sorry, not able to see the expression used here... would you be able to post a screenshot where I can see the expression you have used? Just like the first screenshot posted? Don't need to see the name of the field getting counted
I think you used association_id-id instead of associate_id-id within set analysis
