question How to create a report of all incidents with the same Short Description in Developer forum

How to create a report of all incidents with the same Short Description

brysonelson — Sun, 01 Sep 2019 17:53:45 GMT

Hello,

I am trying to create a report that pulls all incidents with the same short description and a state of "new".

I'm able to create a report that groups all incidents by their short description, however that report still includes all other short descriptions as well.

I'm using the report creator in studio for this.

Any tips?

Thanks

Re: How to create a report of all incidents with the same Short Description

Yash Agrawal1 — Sun, 01 Sep 2019 18:28:40 GMT

Hello brysonelson,

I just create a report with same short descrition .so i get all the short description with count that how many time a incident created with same short description. to check the count of every short description just hover the mouse from the bar u will get the count.

and In Configure Tab just Uncheck the "Show Other" checkbox so you get only that incident which has short description repeated more than 1 . i displayed count on bar itself

I am also attaching the screenshot for your reference.

Please Mark it correct if your work is done by my answer

Thanks

Yash K.Agrawal

Re: How to create a report of all incidents with the same Short Description

Ashutosh Munot1 — Sun, 01 Sep 2019 18:32:41 GMT

Hi,

You only want a report where you want to see duplicate incident where short description is same right?

Thanks,
Ashutosh

Re: How to create a report of all incidents with the same Short Description

brysonelson — Sun, 01 Sep 2019 18:41:21 GMT

Ya, I want to see all incidents with the short description "Contract Expiring in One Week". That way I can send an email notification of all contracts that are about to expire. I don't want to include any other incidents in the report

Re: How to create a report of all incidents with the same Short Description

brysonelson — Sun, 01 Sep 2019 18:45:43 GMT

I only want to show incidents with the short description "Contract expires in one week".

I don't want any other short descriptions included in the report, as I want to be able to email this report, so that I only have contracts that are about to expire included

Re: How to create a report of all incidents with the same Short Description

shloke04 — Mon, 02 Sep 2019 00:48:44 GMT

Hi,

Navigate to "Create New" module available under Reports Application menu and then follow the steps as mentioned below:

Under Data Tab Give a Report Name, then Select Source Type as "Table" and select the Table Name as "Incident"
Under Type Tab select the type of Report as "List"
Under Configure Tab select the columns you want to display and then use Group By as Number.
Give a Filter condition as "Short Description CONTAINS "Your Text" and State is New as shown below

The you can navigate to the module called "Scheduled Reports" as shown below and click on the New button if you want to automatically send this report to users.

Fill out the mandate fields like frequency of the report , recipient of the report and select the Report which you created above ans shown below:

Hope this help. Please mark the answer as helpful/correct based on impact.

Regards,

Shloke