topic Re: set analysis help in App Development

set analysis help

dandaanilreddy — Fri, 15 Jul 2022 16:22:11 GMT

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

Re: set analysis help

stevejoyce — Fri, 15 Jul 2022 16:58:19 GMT

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

Re: set analysis help

dandaanilreddy — Fri, 15 Jul 2022 17:28:35 GMT

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

Re: set analysis help

stevejoyce — Fri, 15 Jul 2022 17:37:09 GMT

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.

Re: set analysis help

dandaanilreddy — Fri, 15 Jul 2022 18:07:01 GMT

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

Re: set analysis help

stevejoyce — Fri, 15 Jul 2022 20:25:31 GMT

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)

Re: set analysis help

dandaanilreddy — Fri, 15 Jul 2022 20:35:46 GMT

It worked. Thank you so much 😊