Filter for Null Values

[#1]

Hi,

I was trying to make a filter on my dashboard for whether or not a ticket is assigned to an actor. The function I entered to do this is:

=if(len(trim(actorname))=0,'Unassigned','Assigned')

When I try to apply the filter as Assigned or Unassigned, in the straight table I have displaying the rest of the ticket information, I see both assigned and unassigned tickets. How should I enter the function into the filter so that it truly reflects both assigned and unassigned tickets?

Thanks

[MK_QSL · Accepted solution]

you can do anyone of below

1) Create a Flag in script for Null and NonNull Values

If(Len(Trim(actorname))=0 or IsNull(actorname), 'Unassigned','Assigned') as Flag

Now you can use Flag List box to filter null values using unassigned

2) Create a dummy actorname for Null values

If(Len(Trim(actorname))=0 or IsNull(actorname), 'Dummy',actorname) as actorname

[#3]

Thank you!