Help request: How to compare and visualize the tickets with given estimation and reported time?

Question

Hello, dear community,

I am trying to find a way to represent in a dashboard all the ticket types with the provided estimation and reported time on them. In other words, to show somehow overestimated or underestimated tickets.

Tried with the "workratio > 0" but again this JQL in addition to status filtering will not do the job. My idea is to use this in a custom chart.

If someone has an idea how to help, I will be grateful.

KR,

Stephan

Stephan Georgiev-Ashkenazy · Answer

Thanks a lot, dear Егор!

I understand your point and it looks excellent to me. However, I am not aware of how the calculation could be done. Read some posts that JQL doesn't have mathematical functions in it.

Let's say that my query looks like:
project = "My_project" AND timeoriginalestimate > 0 AND timespent > 0 AND status not in (closed, done, rejected, Canceled, Completed, Resolved) ORDER BY key ASC

I am not familiar as well, how to create this customer field. Let me say that I have no administrative rights in the project and JIRA, so I am not sure if it will be possible for me.

I would appreciate your further feedback.

Azithromycin · Answer

To compare and visualize tickets with given estimation and reported time on a dashboard, you can create a custom Jira Query Language (JQL) filter to identify tickets with both "Original Estimate" and "Time Spent" fields populated. Then, use this filter in a custom chart gadget on your dashboard. Consider creating a custom field to calculate the deviation between the estimated and reported time, and use it in the JQL to specifically highlight overestimated or underestimated tickets. While "workratio > 0" might not suffice, a custom field for deviation and a tailored JQL query will azithromycin help you effectively showcase this information in a visually intuitive manner on your dashboard.

Best regards, Mr. Zpak