How to create a report to show the ticket count on the daily basis using Created field in ServiceNow

[Abhi7]

I want to create a Report to show the Ticket counts on the Daily basis, but I only have "Created" field which is a Date/Time field and hence the Aggregation couldn't be done on Date only, it considers time as well for each group.

Please help me creating the Report.

Thank you

[CFrandsen]

Hi @Abhi7 . 
You could achieve this by doing it like this:

1) Data Source: Select your table (eg. Incident)

2) Metric: Set to "Count"

3) Trend by: Date by created  

Should give you something like this (dummy data):

 

 

 

[Abhi7]

Hi @CFrandsen 

Thank you for the help but I had already tried this and it is showing percentage column as well along with the count column. Could you please help me in removing the percentage column if it is possible.

Thank you

[CFrandsen]

The only way to do this, is do disable the data table for the report - but that would also remove the count... 

Sounds like your usecase is starting to align a bit more with Performance Analytics? 
In order to do trend and aggregations as individual counts ?

[Dinesh_Now]

Can you try below steps once--

Steps to Create a Daily Ticket Count Report

1. Go to Reports → Create New

   • Type: Reports in the left navigation → Click Create New.

2. Choose Table

   • Select the table with tickets, e.g., Incident or Task.

3. Report Type

   • Choose Time Series → Line Chart or Bar Chart.

4. Set Time Interval

   • Time field: Created

   • Interval: Daily

5. Aggregate

   • Aggregate type: Count

   • This counts how many tickets were created each day.

6. Filter (Optional)

   • Add filters if you want, e.g., only Active tickets or a specific category.

7. Save & Run

   • Give your report a name and save.

   • You can also add it to a dashboard for daily monitoring.
     refer SS for ref

     

     If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.