Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
count({<ticket = {"=(time_spent-original_time)/original_time)<0"}, status = {'Closed', 'Resolved'} >} ticket)
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
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.
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
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)
It worked. Thank you so much 😊