jeffschaper opened a new issue, #8363: URL: https://github.com/apache/incubator-devlake/issues/8363
### 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 The ["1. Change Failure Rate" panel](https://github.com/apache/incubator-devlake/blob/e061ef223a93a28d88bb1238a0acd7d29f39f2b6/grafana/dashboards/DORADetails-ChangeFailureRate.json#L208) on the ["DORADetails-ChangeFailureRate" dashboard](https://github.com/apache/incubator-devlake/blob/v1.0.1/grafana/dashboards/DORADetails-ChangeFailureRate.json) is displaying over 100% <img width="314" alt="Image" src="https://github.com/user-attachments/assets/17ff501e-988a-4567-98ca-e608ee1ff105"; /> ### What do you expect to happen I'd expect the percentage to never exceed 100% ### How to reproduce Select more than one project from the [DORA dashboard](https://github.com/apache/incubator-devlake/blob/v1.0.1/grafana/dashboards/DORA.json), then view the ["1. Change Failure Rate" panel](https://github.com/apache/incubator-devlake/blob/e061ef223a93a28d88bb1238a0acd7d29f39f2b6/grafana/dashboards/DORADetails-ChangeFailureRate.json#L208) on the ["DORADetails-ChangeFailureRate" dashboard](https://github.com/apache/incubator-devlake/blob/v1.0.1/grafana/dashboards/DORADetails-ChangeFailureRate.json) ### Anything else We're noticing the bug with 13 projects selected from the project list. It's not clear to me if this is an aggregation issue with 13 projects, when the dashboard is expecting one or if the SQL query should take this into account. It appears something similar happened before in https://github.com/apache/incubator-devlake/issues/4610 ### Version v1.0.1 ### 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
