I have 2 requirements and I need some suggestions here as to how to best achieve it
1. Build a Metric definition based on calculation of % of unsuccessful changes - Formula - Total closed Unsuccessful Changes / Total closed changes * 100
How to achieve this? Any way we can use Calculated metric definition for it? If so can you please guide on the process? Or we can use scripted metric definition?
2. Build a Metric definition to show number of incidents created as a result of change, the filter is straight forward but for the threshold the requirement is to have 3 values - Increasing, Decreasing and Stable and the logic is Increasing will be based on last month data, same for decreasing based on last month and stable meaning no change.
Anyone having any experience with these requirements?
