COUNT with multiple conditions

[PaoloGuerra]

Hi all,

I have a counter with a specific condition

Count({<userAccountControl={'66048'}>}userAccountControl)

But i need to add these 3 multiple conditions on the same function, but I don't know how I can do it.

If(AccountExpirationDate = '<>', AccountExpirationDate)

If(UserPrincipalName like '*direzione*' or userAccountControl like '*gfs*' or userAccountControl like 'servizi',UserPrincipalName)

If(Title = 'Dipendente' or Title like '*Esterno*' or Title like '*Consulent*',Title)

Can we help me please?

Thanks

[Channa]

if(userAccountControl ='66048' and ( match(UserPrincipalName ,'*dire*') or match(UserPrincipalName , '*gfs*') or match(UserPrincipalName , '*serv*'))
and (Title='dependent' or match(Title,'Esterno') or match(Title,'cons')),count(userAccountcontrol))

it should work

[PaoloGuerra]

Hi,

I have an error. I think is about dual if or not specified

[Channa]

if(userAccountControl = 66048 and match(UserPrincipalName, '*direzione*'),count(UserAccount))

can you check this

[PaoloGuerra]

No results

if(userAccountControl = 66048 and match(UserPrincipalName, '*direzione*'),count(userAccountControl))

[Channa]

one last try

=if((userAccountControl = 66048 )and (UserPrincipalName like '*direzione*'),count(userAccountControl))

[PaoloGuerra]

Good morning @Channa ,

same result. Not working 😞

[Channa · Accepted solution]

add 2 new columns

 IF(lower(Title) like '*ester*' or lower(Title) like '*consu*','B1','B2') as TitleB,

   if(UserPrincipalName like '*gfs*' or UserPrincipalName like '*direzi*' or lower(UserPrincipalName) like '*servi*','C1','C2') as UserPrincipalNameB

after

=count({<UserPrincipalNameB={'C1'},userAccountControl={'66048'},TitleB={'B1'} >}userAccountControl)