if statement to set analysis

[israrkhan]

Hi Guys.

can some one help me to convert below if statement into set analysis.

=count(  if(   (status = 'Closed' or status = 'resolved' ) and( measurementstatus = 'missed') and if (assigned_group like '*client*', title like '*abc*' , title like '*cde* )   ,  number  )    )  

your help would be much appreciated...!

Thanks

Khan

[lironbaram]

hi

it should be something like

count(  {< status = {'Closed' ,'resolved' }, measurementstatus = {'missed'},assigned_group ={ '*client*'}, title={ '*abc*','*cde*' }>}  number  )     

[sujeetsingh]

count(  {< status = {'Closed' ,'resolved' }, measurementstatus = {'missed'},assigned_group ={ '*client*'}, Wildmatch(title, '*abc*','*cde*')={1}>}  number  )

[#4]

Hello IsrarKhan,

Try the below set analysis.

COUNT({<Status={'Closed','resolved'},measurementstatus ={'missed'},assigned_group={'*client*'},Title={'*abc*','*cde*'}>}Number)

[jagan]

Hi Israr,

Try this

=count( {<status ={ 'Closed', 'resolved'} , measurementstatus = {'missed'}, assigned_group ={'*client*'}, title={'*abc*','*cde*'}>} number )

Hope this helps you.

Regards,

Jagan.

[israrkhan]

Thanks guys..

You assigned *client* to assigned_group all the time..

But i have to check if Assigned group = *client*

When Assigned_group =*client* then take *abc* else take *cde*..

Just read twice, you will get it..i think p () function will be use here....

[israrkhan]

Kindly see the original question, having paroblem in red area...the second if statement...

[sasikanth]

HI,

Try some thing like

Script level :

load *, wildmatch( assigned_group,'*client*') as FLAG;

load * from table;

Expression:

=count( {<status ={ 'Closed', 'resolved'} , measurementstatus = {'missed'},title={"$(=pick(wildmatch(FLAG,1,0),'*abc*','*cde*'))"}>}number )

[jonathandienst · Accepted solution]

Your original post was not very clear. Try this:

count({< status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}, assigned_group = {'*client*'}, title={'*abc*'}> +

< status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}, assigned_group -= {'*client*'}, title={'*cde*'}>} number)

[jonathandienst]

This should work also:

count({<status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}> *

(<assigned_group = {'*client*'}, title={'*abc*'}> + <assigned_group -= {'*client*'}, title={'*cde*'})>} number)