It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes
Nic Brough Community Leader Jun 22, 2017

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.

Nic Brough Community Leader Jun 29, 2017

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

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

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
Published in Confluence

Confluence Server & Data Center 7.0 is here!

Hello Community 👋🏼 I’m Makisa, a product manager on Confluence Server and Data Center. Confluence Server & Data Center 7.0, our latest platform release, is now available and we wanted to shar...

157 views 0 11
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you