dosubot[bot] commented on issue #8363: URL: https://github.com/apache/incubator-devlake/issues/8363#issuecomment-2755663783
<!-- Answer --> The issue with the "Change Failure Rate" panel displaying a rate over 100% when multiple projects are selected is indeed related to the SQL query. The current query aggregates incidents and deployments without distinguishing between projects, which can lead to an inflated failure rate when multiple projects are selected. This suggests that the query is not fully accounting for the distinct separation of deployments across different projects, which is why the rate can exceed 100%. Therefore, it can be considered a bug in the SQL query design, as it does not handle the aggregation correctly when multiple projects are involved. The query should be adjusted to calculate the change failure rate separately for each project and then aggregate the results to ensure the rate does not exceed 100% when multiple projects are selected <sup>[[1]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORADetails-ChangeFailureRate.json)</sup><sup>[[2]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORA.json)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/5732b317-3c68-4b30-9e53-b53fb3c83f14?feedback_type=other)</sup> -- 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 For queries about this service, please contact Infrastructure at: us...@infra.apache.org
