[steven_stewart Contributions: 0Level 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: 0Level 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.

[Author]

Posts