[Bug][Grafana] Weekly bug Retro dashboard contains bugs in rejected status

[KyriosGN0]

Search before asking

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

What happened

the Weekly bug retro dashboard contains bugs that were rejected

What do you expect to happen

the dashboard should not contain bugs in rejected status

How to reproduce

open the dashboard, see that it contains bugs that were rejected

Anything else

No response

Version

1.0.2-beta4

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

[dosubot]

The current logic for the Weekly bug retro dashboard does not explicitly filter out rejected bugs. The SQL queries focus on filtering by issue type, board ID, and status for closed bugs, but there is no mention of a specific status or flag for rejected bugs in the available information ^[1].

To address this issue, you could modify the SQL query to exclude bugs with a rejected status. This would involve adding a condition to filter out issues with the rejected status in the relevant parts of the query. If you are willing to submit a PR, you might consider adding a condition like and status != 'REJECTED' to the queries that fetch bug data for the dashboard.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}