Could not create a bar chart with my JIRA filter

Hello,

 

I have multiple filters in my JIRA. Ex: i have filter in the project with 500 total bugs in that i have 300 bugs, 100 iimprovement, 50 new features and 50 tasks. I  want this in a bar chart and x axis with number i want bugs, improvement, new features, and tasks and in y axis want count of the tickets.

 

I tried to liked with confluence and tried in JIRA also. Could not create it. Help me to make my own chart in that.

 

Thanks,

Arutkavi Gunaseakaran

3 answers

This widget could not be displayed.

Go to the Jira dashboard, and add a "filter statistic" gadget.  Put your filter in it, and then select "issue type" as the statistic.

It will have x and y the wrong way around, but it is the closest you'll get without coding.

Hi Nic,

Sorry for the late reply, I have already created x y table. But from that i want to create a bar chart. I can easily create a pie chart with this data. But chart macro is not helping to create bar chart. Can you have any idea how to create this.

First, does the "filter statistic" in JIRA work ok?  Apart from the axes being reversed, of course.

If it does, then you'll have to explain what you mean by "chart macro is not helping" in Confluence?  I can make the simple ones work by filling in the questions it asks.

Yes it is working. I got it. Found a way to create it. Anyway thanks for your responce

This widget could not be displayed.

Hello Arutkavi,

This is possible and not too difficult to do with Table FIlter and Charts add-on. You'll need to create the following structure in the editor: Chart from Table macro -> Pivot Table macro -> JIRA macro or a JIRA gadget (like Nic said). Then save the page.

Then in pivot table select T (type) column in Row Columns parameter - you should get a table with first column containg issue types and the second column with count for this types. And save changes for pivot macro.

Then in Chart from Table macro change type to Column or Bar (or you may leave the default pie type) and save changes in the macro.

As a result you should get something similar to this.

Hi Andrey,

 

I got your steps appologies for late reply. Here the table is created is from JIRA filter. So it dosnot showing the pivot chart option in edit mode. Becasue the date was getting from the JIRA filter dynamically. So I want to create it from chart that is created from JIRA filter. Take a look at these snapshots Chart_after_creation.jpgConfluence edit mode JIRA chart.jpg

This widget could not be displayed.

Inside chart Create a chart -> select chart type as bar then you will able to see  it. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

603 views 8 6
Join discussion

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