Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Issue is as followed:
i am writing a set analysis statement for counting tickets sla_value is not eual to detached ( SLA_Value-={'Detached'}).
But it is also excluding tickets where Sla_Value is blank(' '). I need those values to be included in the count and only the tickets with sla_value as Detached to be excluded.
May be this:
{<SLA_Value -= {'Detached'}>+<SLA_Value = {"=Len(Trim(SLA_Value)) = 0"}>}
one more approach would be is to add a flag for the null SLA_Value in the script and you could use the same in the set analysis
{<SLA_Value -= {'Detached'}>+<SLA_Value_Flag = {1}>}