Expressions problem with several listboxes.

[#1]

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!

[tresesco]

Try like:

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

[#3]

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!

[sujeetsingh]

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)))

[tresesco · Accepted solution]

Simply adding the queue part should work, like.

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