Hi @pramn ,
Open the Report Module
In the Application Navigator, type:
Reports
Click Reports > Create New
Choose the Table
Select the table you want to report on.
Examples:
Incident → Incident reports
Change → Change reports
Request → Service Catalog reports
Custom table → Your custom data
Example: Select Incident
Click Next
Select the Report Type
Choose how you want to display data:
Type Use Case
List Show records
Bar Compare values
Pie Show percentage
Time Series Trend over time
Pivot Summary report
Example: Choose Bar Chart
Click Next
Apply Filters (Conditions)
Set conditions for your data.
Example:
State = Open
Priority = 1
Created = Last 30 days
Click Run
Configure the Report
Now customize:
Group By
Choose how to organize data.
Example:
Group by → Assigned to
Group by → Category
Aggregate
Choose what to count/sum.
Example:
Count → Number of incidents
Sum → Hours worked
Save the Report
Click Save
Give a name
Select application
Set visibility
Click Submit
Add Report to Dashboard (Optional)
Open Self-Service > Dashboards
Click Edit
Add your report widget
Please refer this for more info
https://www.servicenow.com/docs/r/now-intelligence/reporting/t_CreateYourOwnReport.html?utm_source=c...
If this solution solves your issue, please mark it as Accepted Solution.
