A weekly report showing tickets raised each day

[scottjus82]

Hi,

I am sure this is yet another simple thing to do and I am not looking in the right place. I would like to create a report for all team leaders that would be run weekly that shows calls opened each day of the week and what the status is. currently if I run the report by opened and assigned to it displays the opened in number of days/weeks instead of Monday/Tuesday/Wednesday etc. I have tried varients of grouped by assigned team with stacked as opened and vice versa.

Any thoughts?

Thanks

[randrews]

One other thing kind of odd.. check your task table for which fields are indexed... in ours opened <which is the same as created on us> is indexed and opened isn't...

so a report like this will take MUCH longer if they use created than if they use opened... by much longer i am talking about i have reduced load time from 5 minutes <we have a LOT of task records> to a few seconds.

knowing which fields are indexed on   your tables can REALLY help in reporting.

_____edited to change created for to created on.. sorry typo

[geoffcox]

You can get indexing added to particular fields if you are experiencing performance problems. Just open an incident on HI.

[Clayton3]

I'm having the same issue, my volume is being grouped by day, whereas I want to show a trend by day over time.

[Clayton3]

I've been able to resolve this with help from one of the comment above (use Date vs Day in the configuration settings).

[Arun Prakash A1]

Yes this can be created using Trend chart based on "Type as Spline, Trend by 'Assignment group' per 'Date' and Group by created.