Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am new here and I am trying to build a chart that should count unique employee number plus a lot of filters.
Can anyone please check what I am doing wrong with the following set expression?
Count distinct[Employee Number]{<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'}>}[Employee Number])
Thank you in advance
apart from the Opening bracket for Count() , there is redundant field name
Corrections highlighted
Count ( distinct[Employee Number]{<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'}>} distinct [Employee Number])
Your final expression should be as below
Count ( {<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'} >} distinct [Employee Number])
apart from the Opening bracket for Count() , there is redundant field name
Corrections highlighted
Count ( distinct[Employee Number]{<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'}>} distinct [Employee Number])
Your final expression should be as below
Count ( {<[Employee Type]={'Permanent','Casual','Union'},[Status]={'Active','Leave of absence'},[Updated BU]-={'NONE'} >} distinct [Employee Number])
Thank you so much @vinieme12 ! You saved my day!