Reporting on average number of tickets in a queue per month

[Ben88]

Hello,

I would like to know how can I create a report of the average number of tickets (at the end of a day )in a queue per month. 

Please let me know if you need further informations.

Thanks a lot,
Regards

[Dhananjay Pawar]

Hi Ben,

You can create indicator source for that and define automated indicator under indicator source.

Next you can create collection job to collect the score of ticket.

Then create widget and add indicator in widget and add that widget under dashboard so you will get report of ticket.

Thanks,

Dhananjay.

[Prithviraj Howa]

Hello Ben,

Navigate to performance analytics module.

1.First create Indicator source. In that set frequency to monthly, Fact table and conditions as per your convenience. This is how I set.

2. Create Indicator. Add indicator source in Indicator and take Aggregate as Average and choose Field as per your convenience. Here is what I done.

3. Create new Data collector. After saving it ,add Indicator in Data collector by rolling down to Related list to collect the data from Indicator. Here is how I done. 

4. Then create a Widget and add to Dashboard. Here is how I created a widget.

If you find that answer is specific then mark it as Correct and Helpful.

Warm Regards,

Prithviraj Howal

SNOW Developer

[Ben88]

Hi, 

thanks a lot for both your answers. 

Is this possible without Performance Analytics module ? 

[Dhananjay Pawar]

Hi,

How you are defining particular ticket is in queue?Is there any field to define that?

Thanks,

Dhananjay.