Announcements
cancel
Showing results for
Did you mean:
Not applicable

Expressions problem with several listboxes.

Hello!

I have a graph with the expression:

Sum({\$<queue={643,646}>} answ_call_cnt)

I also have a list box named: queued_and_answ_call_dur.

I want the Sum for answ_call_cnt to show only for the values over 30 in the queued_and_answ_call_dur.

How do i write an expression like that?

Thank you!

1 Solution

Accepted Solutions
MVP

Simply adding the queue part should work, like.

Sum({<queue={643,646} , queued_and_answ_call_dur={">30"}>} ans_call_cnt)

4 Replies
MVP

Try like:

Sum({<queued_and_answ_call_dur={">30"}>} ans_call_cnt)

Not applicable
Author

I still only want to do it for Queue 643 and 646.

And i dont want it to Sum first, i want it to Sum all values OVER 30!

Thanks!

Master III

Erik just what to do is that derive a flag for the Queue 643 and 646  with call duration >30 and then use this value in your set analysis.

You can use nested if

=sum(if(Queue=643 OR Queue=646,if(queued_and_answ_call_dur>=30,ans_call_cnt)))

=if(Queue=643 OR Queue=646,if(queued_and_answ_call_dur>=30,sum(ans_call_cnt)))

MVP

Simply adding the queue part should work, like.

Sum({<queue={643,646} , queued_and_answ_call_dur={">30"}>} ans_call_cnt)

Community Browser