This topic contains 1 reply, has 0 voices, and was last updated by JCirocco 8 years ago.
-
Posts
-
steven_stewart- Contributions: 0
- Level 1
- ☆
Good Afternoon,
My apologies if this is a ridiculously rookie question but I have developed a Custom Record which acts as our IT HelpDesk Environment (I'm sure a few of you heard of this on here already haha). I am trying to develop a search that displays the number of open, closed, pending tickets (which is just a custom list within the record called "Status"). This is super-simple with a KPI, but I am unable to schedule a KPI to email out (unless you know of a way, it just seems to be a dashboard item). Essentially, in the search, I just want it to display the total for each status, report-style. Any ideas on how I would make this happen would be greatly appreciated. Thanks in advance folks!
Best Regards,
Steve
This is a cached copy. Click here to see the original post. -
JCirocco- Contributions: 0
- Level 1
- ☆
If you use a formula similar to:
decode{custom_status}. 'Open', 1
decode{custom_status}. 'Closed', 1
decode{custom_status}. 'Pending', 1
and additional lines for the other status's
you could then Group the Status field and Sum the status counters. You would end up with the count in each column.
You must be logged in to reply to this topic.