set analysis help

[dandaanilreddy]

Hello All,

I have written expression using if condition. I want to ignore a selection for the below expression. Please let me know how to write the below expression in set analysis or how can i ignore selection in below expression.

count(if(((time_spent-original_time)/original_time)<0 and match(status,'Closed','Resolved'), ticket))

Thanks

[stevejoyce]

count({<ticket = {"=(time_spent-original_time)/original_time)<0"}, status = {'Closed', 'Resolved'} >} ticket)

[dandaanilreddy]

Hi Steve,

Thank You for responding to my post. The above expression is not giving me any output. My result should show as 1 using the if condition expression.

Note: time_spent and original_spent is coming as numbers from DB.

Thanks,

Anil

[stevejoyce]

that expression should work.  i suppose i'd need to see more info why it's not working if you want to give a screenshot or sample data/app.  check the expression and make sure there are no errors like a syntax or different field name.

[dandaanilreddy]

Hi Steve,

Your expression is working but i want to ignore selection called assignee. I have list box that contains assignees when user select any value i don't want my kpi to reflect results for that selection. Tried below but it reflecting selection.

count({<ticket = {"=(time_spent-original_time)/(original_time)<0"}, status = {'Closed', 'Resolved'} , Assignee=>} ticket)

Thanks

[stevejoyce · Accepted solution]

you'll need to get the ignore assignee into the ticket expression.  try this...

count({<ticket = {"=(only({<Assignee=>} time_spent) - only({<Assignee=>} original_time))/(only({<Assignee=>} original_time))<0"}, status = {'Closed', 'Resolved'} , Assignee=>} ticket)

[dandaanilreddy]

It worked. Thank you so much 😊