How to crete report for the rolling sum?

[shkabuzar]

Hi,

Please tell me how to built a report for the running sum and running average of total tickets over the month by month. Thanks.

[pvet]

To create a rolling sum on closed or open incidents you need to follow these steps:

• Create a new widget of the type Time Series
• Set the indicator to "Number of incidents resolved" or "Number of open incidents"
• Set the Time-Series to "By Month SUM" or "By Month AVG"
• Set the visualization to "column" or "line"

Cheers,

Pim

[shkabuzar]

Thanks Pim for quick response, I don't have time series widget in my SNow. Is there any way to full fill the my requirement in report itself .

[Vincent Loffel1]

Hi Abuzar,

Are you using Performance Analytics or reporting?

Cheers,

Vincent

[shkabuzar]

Hi Vincent,

Am using reporting only, Could you please tell me how to do this? thanks