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

[brysonelson]

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

[shloke04 · Accepted solution]

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