tc-jason-gregory opened a new issue, #7971: URL: https://github.com/apache/incubator-devlake/issues/7971
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened On the DORA home dashboard, the Change Failure Rate shows one value. When you drill into the data and go to the "DORA Details - Change Failure Rate" page, the value is different.   ### What do you expect to happen I expected the values to be the same. ### How to reproduce On the DORA home dashboard, the Change Failure Rate shows one value. When you drill into the data and go to the "DORA Details - Change Failure Rate" page, the value is different. ### Anything else I noted the queries are different for incident counting l as follows... 1. The first query counts incidents using this logic: `count( distinct case when i.id is not null then d.deployment_id else null end ) as has_incident` This effectively counts the deployment if it is linked to any incident. 2. The second query simplifies it to: `count(distinct i.id) as has_incident` This directly counts the distinct incident IDs, which might yield different results depending on how deployments are linked to incidents. ### Version v1.0.1-beta7@3f84bae ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org