bar charts based on linked issues

Hello.

I have tried to find a very fundamental function regarding to show statistics for our JIRA issues. After going through the entire marketplace for the JIRA gadgets I failed to find someone that can do this:

I want to show a specific number of bars , or all bars that fits in a specific timeframe at the X axis in a diagram. The bar diagram should be based on a search filter, that gives the following fields:

Linked issue, Date, and Status (custom field)

The Linked issue field should be the field that ties the statistics together to a bar, and the Status should color the bar. So for instance if I have the following filter search:

Linked issue, Date, and Status

1, 140612, Passed

1, 140612, Failed

2, 140612, Passed

3, 140611, Failed

This search response should generate 3 bars (since there are 3 linked issue types 1,2 and 3). 2 of those bars (related to linked issue 2, and 3) should have height 1 and be colored red for the Failed status and Green for the Passed status. The third bar (related to linked issue 1) should have height 2 and half should be green and the other half red, since there are 2 responses linked to the same linked issue.

The closes I get to what I want to achieve is with the gadget Arsenale Dataplane, with the "Current Issue Values" report. But the problem is that this gadget can't use Linked Issue as the parameter key used to tie responses together to a bar.

I've also tried to install the Bar charts for JIRA, but there is a problem regarding certificates since we are using https, that seems unsolvable.

Can someone suggest some other gadget that does the thing I want to achieve?

Regards Stefan

4 answers

Hi Stefan,

Can you explain what "Linked issue" represents in your example? Is this a custom field? A specific type of issue link to another issue (or set of issues)? Or something else?

Do the "1", "2" and "3" refer to issue types (like you suggested at one point above), or to actual issue IDs, or something else?

Also, where does the "Status" come from? I understand it is a custom field, but if you are linking issues, from which issue?

Lastly, what dates does the "Date" column represent?

If you explain where that data comes from, I will be happy to suggest how to make the appropriate fields or values available in the appropriate place in Dataplane.

- Scott @ Arsenale

Hi Scott and thanks for quick response.

The Linked issue in my case is a Jira native issue link, which is found under "Issue Links" if you view the issue. the value for Linked issues in a issue filter search is shown under column Links

So in my example in my original post, there are two issues that link to the the same issue with issue key 1

Sorry, I forgot to answer all your questions in your answer.

So the Linked issue is what is sounds like. The issue that is linked from the issue sound in the search result.

1,2,3 is issue keys. Actually the look like STRING-1, but only wrote 1 to simplify

Status is a custom field that is set in all 4 issues in the search response, to either "Passed" or "Failed"

Date is the Created field, with value as a date when the issue was created.

Thanks for the extensive description. I'm almost there now, but the chart is'nt showing correctly. I followied your description exactly. I have got the Parent Test field as a column in the answer of the jql, like this:

Status Key(Child) Parent Test
Failed AUTO-131 AUTO-127
Passed AUTO-129 AUTO-127
Failed AUTO-126 AUTO-122
Passed AUTO-124 AUTO-122
Passed AUTO-119 AUTO-117
...

total of 18 hits

However, my chart looks like this:

Curent Issue Values

For segment by I am using Status field, and for Value Of I am using Parent test, like in your example above.
I expect to have multiple bars, where one of them is for the Parent Test AUTO-127 with height 2 (since there are two linked issue to that issue), coloered half blue and half red.

I have Arsenal Dataplane version 1.8

It seeems that the picture is'nt working for some reason. Anyhow, the chart looks is just containing one bar, with height 18. At the Y axis (named Parent test) the value is "None"

Stefan,

Could you please drop us a brief note with your email address (referencing this URL) on our support page? Please also include your database type (name and version) just in case that is relevant. We can follow up with you directly offline and post any final responses back here.

To figure out what is going on, I would also try temporarily adding a segmentation of "Issue" to the configuration to see if the issues represented in the chart are the ones that you expect. If the issues are correct, then it looks like it might be an issue related to the JIRA indexing.

Thanks!

Scott @ Arsenale

Hi again.

I have had a mail correspondence with Arsenale Support team and here comes a summary.

I had to do a JIRA reindex in order to get the chart in the correct way. After the reindex, recreate the Current Issues Value report again in the gadget, and then push the blue "Run Report" button from the report Configuration page. The chart is showing one bar for each unique Parent Test value that the Search critera in the report gives. The bars are showing correct height with correct colors mapped to the Statuses. After the reindex the chart stays correctly and gets updated when for example more issues are added (which is found by the report Search critera), without another reindex.

A side note to this is that it is not functional to use ORDER BY in the search critera, since this report will order the bars according to the number of issues in the bar. Since I want to show trends over time, I need to order the bars by for example Created Date field. Arsenale is saying that support for more customizable ordering which would enable this is probably added in an upcoming release.

Hi again.

I have had a mail correspondence with Arsenale Support team and here comes a summary.

I had to do a JIRA reindex in order to get the chart in the correct way. After the reindex, recreate the Current Issues Value report again in the gadget, and then push the blue "Run Report" button from the report Configuration page. The chart is showing one bar for each unique Parent Test value that the Search critera in the report gives. The bars are showing correct height with correct colors mapped to the Statuses. After the reindex the chart stays correctly and gets updated when for example more issues are added (which is found by the report Search critera), without another reindex.

A side note to this is that it is not functional to use ORDER BY in the search critera, since this report will order the bars according to the number of issues in the bar. Since I want to show trends over time, I need to order the bars by for example Created Date field. Arsenale is saying that support for more customizable ordering which would enable this is probably added in an upcoming release.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

688 views 6 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you