Multiple Expressions with Set Analysis

[#1]

Hi there

I need to have set analysis on two expressions in my chart.  BUt it's not working.  Please help?

At the moment it looks like this.....

Expression 1 (Open) :

Count({1 <Active={"Open"}>} [Helpdesk number])  - Count({1 <[SLA status]={"SLA breached"}> }[Helpdesk number])

Expression 2 (Open Breached) :

Count({1<[SLA status]={"SLA breached"}> } [Helpdesk number])

[jonathandienst]

Hi

Remove the space between the 1 and the <

HTH

Jonathan

[alexandros17]

unfortunately  this part of expression

<[SLA status]={"SLA breached"}>

doesn't work with set analysis because the right element must be a unique  value not a field, that is you cannot compare a field (SLA status) with another field SLA Breached in this way but only using an aggregated function on the second field ex. Max([SLA breached])

hope this helps

[#4]

Thanks for your response Jonathan, but unfortunately it doesn't solve the issue.

[#5]

Thank you very much for you response Alessandro.

"SLA Breached" is not a field.  It's a possible value for the field [SLA Status].  Hope Im making sense.

[alexandros17]

You're right, sorry, I didn't notice the apex, in this case the syntax seems correct (Only try to replace double with single quotes " with ')

if it doesn't work take a look to data ...

(I suggest to create a flat table, then show all values)

[#7]

I've tried to use single quotes.  Still no difference. 

[#8]

For the first expression.... If I remove the second part (where I want to subtract), it works fine.

[morganaaron]

Does the second expression work?

[#10]

HI Aaron.

The second expression works perfectly.

I notice, that if I change the minus sign to a plus ( + ) or multiply ( * ) or divide ( / ), then it works.  BUt for the minus, it just gives me NOTHING .  I don't know if that carries some significance to the issue.