Use custom 'story point' field to create burndown chart

Question

Hi All,

Today I've been trying to create a specific burn-down/up chart with some customized field. I know within reports and burn down gadget it does the trick, but it does not support custom fields. Hence, the reason why I'm trying to achieve a similar graph with custom field instead of 'story point'. I have my reasons for that, that is not why I seek help.

I'm trying to use 'JavaScript Charts for Jira Cloud', there is even an example for burn down. Despite that, I'm failing to create the graph I want... The gadget field seems to show some JQL error, while I assembled the JQL using the issue finder. It works there, so I assume no issue. The gadget even has an JQL editor, even my query is working fine.

The result is always the same, nothing is shown on the graph, while the JQL field is return the following error:

Error in JQL Query: The IN operator does not support the use of the during (startOfDay(), endOfDay()) predicate.

Used JQL:

project = "A4MMI4" AND Sprint IN (openSprints()) AND issuetype = "Requirement" AND status IN (in-specification, Specified, "requirement changed", unspecified)

Bill Sheboy · Answer

Hi @Mathieu Hebbrecht -- Welcome to the Atlassian Community!

Adding to Walter's answer...

That symptom is a known issue with the way the gadget dynamically adds to the JQL for the time series.  You may read one example of that defect here: https://bitbucket.org/dboyd-atl/javascript-charts-for-jira-cloud/issues/128/error-in-jql-query-the-in-operator-does

I just tried this and reproduced the symptom.  And, I was unable to add a new issue to the repo (as the marketplace suggests) so contacting Atlassian Support seems like a good next step.

Kind regards,
Bill

Danut M _StonikByte_ · Answer

Hi @Mathieu Hebbrecht,

You best option here would be our Great Gadgets app. It offers all the gadgets you need for tracking you project by any numerical custom field. With a few clicks you will get:

Sprint Burndown Burnup Chart gadget

Release Burndown Burnup Chart gadget

Besides these great burndown charts you'll get Team Velocity Chart gadget that supports custom fields, so a complete solution.

See more example of these gadgets here: https://community.atlassian.com/t5/App-Central/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063

The app has a free trial of 1-month. If you need any help with the configuration, please contact support@stonikbyte.com.

Danut.

Walter Buggenhout · Answer

Hi @Mathieu Hebbrecht and welcome to the Community!

From your screenshots and explanation, I can't see where the error might be coming from, so looks like a mishap in the app at first sight. I would normally recommend you to reach out to the app vendor directly in a case like this, but since the app is from Atlassian labs and unsupported, I would say you could try to reach Atlassian support but not with high expectations.

If that doesn't work out, you may want to take a look at the many, many, many supported reporting apps in the marketplace.

Hope this helps!