Adding Less than in an Expression

[nwilliams]

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

[MK_QSL · Accepted solution]

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

[Luis_Cortizo]

Hi, Neil

    Try with: [QueueInteractionsView.QueueTime] = {"<180"}

Hope it helps.

Best regards.

[nwilliams]

So simple!!!!!

Thanks!!!