Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Bizarre.
I've uploaded an app I threw together to recreate the idea and it works fine. I've got expressions there that subtract all breached from open (regardless of it's active status) and also an expression that subtracts all breached that are also open. Does your syntax checker throw up any issues?
This is helping a lot Aaron. I just to fine tune it a bit....