[Bug][Metric] The way to calculate `Change Failure Rate` is not accurate

[Startrekzky]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

The Change Failure Rate can be higher than 100%, which is confusing.

After I checked the doc, the current algorithm is defined as below.

What do you expect to happen

We should define CFR as:

The number of changes(deployments) that causes failure(incidents) / The number of changes (deployments)

How to reproduce

Go to DORA dashboard and see the SQL of CFR

Anything else

No response

Version

main

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct