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

Abhi7 · 4 hours ago

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 · an hour ago

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):

 If this pointed you in the right direction, hit Helpful to spread the good vibes.
✅ If it cracked the case for you, mark it Correct so the next person doesn’t have to reinvent the wheel.