Reporting , query the newly opened tickets per day

[bdr]

Hi

I am trying to generate a report that reflects the newly opened tickets per day, not the total opened tickets on a certain day or week

(Similar I might want a report that does one for closed per day /week)

So not a total of overall open ticket or closed

Data: Table Incident

Type Line

Group by: None

Trend Opened

per: Day

Aggregation Count

Seems to give ok results

But as soon as I want see opened tickets per week this reports starts acting up

Regards

BdR

[rajmasurkar]

Hi BdR,

What is your requirement?

Raj

[bdr]

Hi

I would like to keep track of the incoming outgoing workflow

The most important ones:

Newly opened Incidents and or change requests per day

Newly opened Incidents and or change requests per week (Sum of the 5 Days)

I want to additionally be able to filter these by Assigned user or or department

(How many tickets were assigned that day to…)

I would also like to be able to run a report on how many tickets were closed/resolved each day total and per user or department

Regards

Bas

[Lena_Latham]

Hello BdR.

If you want to do this via reporting, you would want to Trend Opened by "Date" rather than "Day".   The Date function returns an actual date, i.e. April 18, 2016 rather than a day of the week, i.e. Monday.  

Also, if you have premium Performance Analytics, there are Indicators already built for this. The Number of new incidents Indicator gathers a daily snapshot of newly opened Incidents (regardless of State) and the Number of new changes Indicator does the same for Change. You could build a Widget that showed both Indicators on the same chart very easily.

I hope that helps.

Lena