14 Replies Latest reply: Nov 14, 2016 3:00 AM by Anil Mahanty RSS

    Set Analysis for Null and Not Null Values



      I'm trying to create a text object indicating the number of unassigned, open tickets. When I try to use this formula, I think that the $- part of the set analysis is applying to both conditions that I've set, because the number is wildly inaccurate.


      =count({$-<actorname={'*'}, Status={'Open'}>} RequestID)


      Another way I tried to do this was by subtracting the number of tickets with an open and not null actorname value from the total count of open tickets, but when I validated my data, I found that it wasn't working either. For that, I used this formula:


      =count({<Status={'Open'}>} RequestID)-count({<actorname={'*'}, Status={'Open'}>} RequestID)


      Is there a way to get the count of tickets with null actorname values which also have a status of 'Open'?