Report on task created date

[Nicole_k]

Hi All,

I want to create a report to see how many incidents and catalog tasks were created each day for the week,

Table - Task

Type - Would prefer a pivot table

Conditions - 

Task type is Incident or catalog task

And created = last week

So far i have this working but the created field is a date time field so its showing all of the exact times each ticket was created. i just want to know on that date how many of the tickets where created, not the time. 

Example:

Note - I do not have performance analytics

[Uncle Rob]

Only way I know how to get that is with a Histogram.  Not as good as a Pivot, but the pivot doesn't appear to let you specify the trend component of a date or date time, where-as a Histogram will. 

You can get closer by doing group by's and checking the Display Data Table box.

[Andrew_TND]

Hi Nicole,

I've found the pivots on the normal reports (I dont know about PA) are a bit rubbish.

I'd either get the info in excel for a pivot or generate a bar chart or time lapse chart based on the 'Tasl' table.

From there just group it on the 'task type' which will help you to distinguish between incidents, changes, catalog tasks etc.