Report on Performance Analytics

[Meghana_585]

How to create a Report on Performance Analytics which shows average number of tickets created assigned to group day wise in year for the period of one year?

I got the Idea behind how to do this -

1. Create a bucket group for all days in a group i.e. monday, tuesday, wednesday,thursday,friday,saturday & sunday. 
2. Pull the day wise data , create a breakdown based on bucket group.
   
   I got stucked at the point to write a script that pulls day wise data and returned to the bucket group

Any suggestions or script would be helpful.

[AndersBGS]

Hi @Meghana_585 ,

Just create a daily automated indicator source and a daily automated indicator that captures tickets assigned to the specific group. Afterwards create a formula indicator that takes the sum divided by the count. At last, run a historical job collection to capture the data. 

Remember, that even if a ticket has been created and assigned to the specific group, the ticket could have been reassigned, hence it will not be captured.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Meghana_585]

Hello Anders,

Thanks for your reply!

I am finding solution to some other thing. As I mentioned, I need to collect all the tickets created on Monday and then need to find average same for Tuesday and for every day in a week. 
The solution that you have provided is shows average number of tickets in an year on daily basis.

Please give me suggestions if you have any regarding this scenario.