Inclding spaces also in set analysis

[Pulkit_Thukral]

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.

[sunny_talwar]

May be this:

{<SLA_Value -= {'Detached'}>+<SLA_Value = {"=Len(Trim(SLA_Value)) = 0"}>}

[avinashelite]

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