I want to Show the reduction percentage of Incidents using Reports or PA on Dashboard

Mad3
Tera Expert

Hi Community!

 

I have requirement to show the Reduction Percentage on Year to Date (YTD) for P1/P2 incidents compare to current to last year.

Ex:- 45% reduction in 2024 (44) compare to 2023 (80)

 

As my knowledge it is not possible using standard report. So I am thinking to configure using widget in PA.

 

The formula i used is 100-((([[ P1/P2 Incidents 2023]])/([[ P1/P2 Incidents 2024]]))*100)

Indicator source frequency is Monthly.

--> Using this formula indicator in widget not able to find a reduction percentage and also want to see the data by Quarterly or Month on Month comparison.

 

Here i am not able to achieve how to show the number of incidents and reduction percentage like month on month or quarterly for last year and current year.

 

If anyone has gone through the kind of requirement sharing your knowledge can appreciated.

 

Thank you in Advance.

 

 

0 REPLIES 0