How to make a comparison statement?

[pablomind]

Hi, Im working on a HR Dashboard and I need to know how many active employee has more than one position assigne. I have a column of employee ID and another one with positions. Any suggestion?? 

[mohamed_ahid]

can you give more precision about your data model ?

[Anonymous · Accepted solution]

several ways

1) Expression using aggr with empoyeeID as dimension

if (aggr(Count(Position),EmplyeeID) > 1, Count(Position))

2) employeeID as Dimension

  Count(position) as Expression

  Dimension Limit (Show only values thar are gretaet than 1 exact amount)

-> only if Count (Position) is first expression

[swuehl]

Maybe something like

=Count({<EmpID = {"=Count(DISTINCT Position) >1"}>} DISTINCT EmpID)

[pablomind]

Thank you HRLinder‌ your first suggestion solved my problem.

[oknotsen]

It seems you have the answer to your question. Now it is time for you to flag the correct answer by using the Correct Answer flag.