Expression Needed

[Anonymous]

I have a field called Queue names and a field called Queue Calls.  I need the sum of queue calls when the queue name is "Billing Q".  How would I write that expression?

[marcus_sommer]

Try:

sum({< [Queue names] = {'Billing Q'}>} [Queue Calls])

- Marcus

[sunny_talwar]

May be this:

Sum({<Queue = {'Billing Q'}>} [Queue Calls])

[nitin_01]

Hi Kathy,

Try this:

             Sum({<Queue names={'Billing Q'}>}[Queue Calls])

if not please elaborate your query.

Regards

[Anonymous]

For some reason, the results are return the value x 7 (I have a total of 7 queues). 

My answer should be 5117 but, instead it is 35819.

[sunny_talwar]

Make sure the name of the field match case-to-case. Is the field called Queue Names or Queue names?

[Anonymous]

‌thanks!! That worked.   Now... if I want to add set analysis to populate just the current year's values,  what would I add to this expression?

[sunny_talwar]

Like this:

Sum({<Queue = {'Billing Q'}, Year = {$(=Max(Year))}, Month, MonthYear, Quarter, QuarterYear, Week, Date>} [Queue Calls])

All the fields in red are the other date related fields where you might want to make selection but would not want your expression to be impacted with. So, if you add them in your expression, all the selections will be ignored in those fields.

[Anonymous]

Sum({<Queue Name ={'Billing Q'}>}[Queue Calls])

[Anonymous]

Sunny, Awesome!  So this will pull in 2016 or the current year.  What do I use for adding a measure for the previous year? (Thank you for your help!)