
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis for Null and Not Null Values
Hi,
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'?
Thanks
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count({<actorname-={"''"},Status={'Open'}>} RequestID)
or
Count({<actorname-={"'-'"},Status={'Open'}>} RequestID)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Count({<actorname-={*},Status={'Open'}>} RequestID

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try =count({$-<actorname={'*'}> * <Status={'Open'}>} RequestID)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this
=if(isnull(actorname),count({$<Status={'Open'}>}RequestID))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When I do this I get the same result as I did for the (count({$-<actorname={'*'}, Status={'Open'}>} RequestID)) formula I tried earlier.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This formula gives me a result of 0.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm sorry, I forgot ')' at end of expression

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you may be not having exactly null in your data base some time its blank. use len() function .
So use if(len(actorname)>0,count({$<Status={'Open'}>}RequestID))
Thanks
BKC

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is returning the total number of open tickets, but I don't think the null actor value is narrowing it down any further.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Well nulls will never be part of the current selection, so you needs something like this:
=count({1<actorname -= {'*'}, Status={'Open'}>} RequestID)
or this:
=count({1<actorname -= {'*'}> * $<Status={'Open'}>} RequestID)
If these do not work, I suggest you post your application or at least a sample illustrating the problem.

- « Previous Replies
-
- 1
- 2
- Next Replies »