Automatically calculate month over month trend

[sam222]

Hi Team - I am looking to include the month-over-month ticket volume trend in the servicenow reporting, instead of having to plug the data into spreadsheet or another application. 

I am running a volume trend report on the task table for task types, incident and catalog tasks for the tickets created on this year. 

Group by: Task Type, and Trend by: Created date (per month) --> Aggregation count.

Currently, I have to take the numbers from the servicenow report to spreadsheet and calculate the change in the volume % there.  I was wondering if anyone can offer help to display the calculation in the report itself. 

Thank you in advance. 

[AndersBGS]

Hi @sam222 ,

You should be able to perform the calculation in performance analytics with formula indicators. The calculation that you're looking for is not available through the report designer. 

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

best regards

Anders