% Change month over month..

[Oneimus]

I am trying to create a similar report in PA that compares Current Month to Previous Months and provides a % difference. Similar to this.

[Allen Andreas]

Duplicate post: https://community.servicenow.com/community?id=community_question&sys_id=5da5e7691b1fc550fc3233bc1d4b...

[Hayden69]

To calculate Month-over-Month growth, subtract the first month from the second month and then divide that by the last month's total. Multiply the result by 100 and you're left with a percentage. The percentage is your Month-over-Month growth rate.

mcdvoice

[Oneimus]

I know how to calculate it as that's how I achieved it in Excel. However how is it achieved in PA? How do you capture first month, second month, etc so that you can use the formula? Detailed steps would be appreciated.

[konijetisumanth]

create a indicator sources in that take valid for frequency as MONTHLY

create a automated indicator in that take aggregation as AVERAGE 

In the PA widget take type as TIME SERIES, visualization as COLUM 

In job take relative end and start 30- 0 and run the job daily 

i think this would help