Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Its fair to say my visualisation skills are better than my scripting!!! I'm trying to add an expression to a text ox to show volume of calls under 180 seconds. The expression I wrote works with an "=" but when I change it to "<" it errors. Can anyone help?
Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] < {'180'}
>} (lnk_InteractionId))
Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {'<180'}
>} (lnk_InteractionId))
or
Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {"<180"}
>} (lnk_InteractionId))
Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {'<180'}
>} (lnk_InteractionId))
or
Count (DISTINCT{<QueueInteractionsView.RRDisplayValue={'taken'},
[QueueInteractionsView.c_QueueGroup]={'Central Booking Desk'},
[QueueInteractionsView.QueueTime] = {"<180"}
>} (lnk_InteractionId))
Hi, Neil
Try with: [QueueInteractionsView.QueueTime] = {"<180"}
Hope it helps.
Best regards.
So simple!!!!!
Thanks!!!