How to create a report that shows average number of tickets created on day wise in a week using PA?

[Meghana_585]

How we can create a report that shows average count of tickets worked on each day from past one year?

In a brief how many tickets on Monday, Tuesday and so on in a week from last one year

[servicenowdona]

Creating a report in ServiceNow that shows the average count of tickets worked on each day from the past one year involves several steps. Here's a step-by-step guide:

1. Navigate to Reports > Create New.
2. Select the type of report you want to create. In this case, you might want to create a Bar Chart or Line Chart.
3. Select the data source. This would be the table that contains your ticket data, such as the Incident [incident] table.
4. Define the filter conditions to only include tickets from the past one year. You can do this by setting the 'Created' or 'Updated' field to be 'on or after' one year ago.
5. In the 'Group by' field, select 'Day of Week'.
6. In the 'Calculate' field, select 'Count'.
7. Click on 'Run' to generate the report.

This will give you a report that shows the total count of tickets worked on each day of the week for the past one year. To get the average count, you would need to manually calculate this by dividing the total count by the number of each day in the year.

Please note that this report will only be as accurate as the data in your ServiceNow instance. If tickets are not being correctly logged or updated, the report may not accurately reflect the actual workload.for further details please visit our site https://nowgpt.ai/#/home