topic Re: SLA development in App Development

SLA development

jagadesh — Fri, 23 May 2025 09:52:01 GMT

Hello Everyone,

Actually i'm creating one sla for service inisight. in set expression getting error like Error in expression : ')' expected but i have checked all areas if i missed any paranthesis but unable to found any issue. can any one help me on this. please find the below expression.

(num(count({<State-={'Closed Abandoned'},Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number]),'#.##%')
+ num(sum([MonthFlag]={'Current Month'},
[Answered In SLA])/(sum({<[MonthFlag]={'Current Month'}>}[Calls Offered])-sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA])), '#.##%')
)/2

Re: SLA development

Qrishna — Sun, 25 May 2025 21:29:09 GMT

This should work

= (num(count({<State-={'Closed Abandoned'}, Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number]),'#.##%') +
num(sum({<[MonthFlag]={'Current Month'}>}[Answered In SLA]) / (sum({<[MonthFlag]={'Current Month'}>}[Calls Offered]) - sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA])), '#.##%')
)/2

You dont need nums twice. once is fine.like below:

= num(((count({<State-={'Closed Abandoned'}, Type={'Chat'},wait_time ={'=30.00'}>}[number])/count({<State-={'Closed Abandoned'},Type={'Chat'}>}[number])) +
(sum({<[MonthFlag]={'Current Month'}>}[Answered In SLA]) / (sum({<[MonthFlag]={'Current Month'}>}[Calls Offered]) - sum({<[MonthFlag]={'Current Month'}>}[Abandoned In SLA]))))/2, '#.##%')

Re: SLA development

jagadesh — Tue, 27 May 2025 16:58:13 GMT

Thanks it is working fine

Re: SLA development

Qrishna — Tue, 27 May 2025 17:40:36 GMT

Please close the thread by marking my reply as answer so oher people in need can find it more easily. thnx