Report on basis of short description

[Rachael12]

I need to create a report on basis of Short description on incident table, created in last 15 days. Need to fetch the details of incidents which have same short description and the count is more than 7.

I am able to do so through scheduled job but need to details in excel sheet, so would like to explore in report.

I am unable to group the incidents on basis of incidents.

Thanks in advance

[Sohail Khilji]

Hi @Rachael12 ,

Try this :

Set a condition for Created date > on or after > Today minus 15 days.
Add another condition Group by Short Description.

Aggregation & Count Filtering:

Use Aggregation by selecting Count of Incident Number.

Apply a filter for Count > 7 to only retrieve records where the short description appears more than seven times.

 Grouping the Results:
- Use the Bar Chart or List format to visualize grouped incidents.
- Ensure that Group By: Short Description is applied properly.

[Rachael12]

Hello Sohail,

Thank you for response!
I am unable to group on basis of Short description. PFA
Can you please attach screenshot of the report.