Cutomized X Y Bar Chart for Confluence or JIRA

[Biju.Shankar]

👋 User groups. -> have a similar question related to chart displays in the Confluence page from an earlier tread back in 2018, with Subject: - > Is this what you are looking for? . The earlier thread gets closed with solutions provided by Andrey 

 Pls go over request, share if you have a workable solution too. Details here.

Subject: -ASK = show Monthly Defects Charts, Vertical in the team's Confluence Space/Page. > 

Currently use the following settings to Display defects charts Vertical from table values

Option 1) -> Chart from Table -> type = Stacked Column 3D, Table Data Orientation = Horizontal

Option 2) Noticed display shows only Horizontal.
-> Chart from Table -> type = Stacked Bar 3D, Table Data Orientation = Horizontal

Need/ASK is= show charts Vertical in the team's Confluence Space/Page .

Question ?  Any possibility to show Defect Charts Vertical, if I choose Options 2 ? OR do I need to use Pivot table?

Answer : = 

Question?  : Back in 2018 thread's user Andrey Khaneev _StiltSoft shared a sample chart display Vertical. See details here. 

Answer: = 

Question?  How to display the Y axis numbers in percentile %  

Answer: 

 Question?  How to display the numbers on middle of each monthly charts  

Answer : 

Sharing here for your references how the chart displays from MS excell 

Answer : = 

Any tips to address the ASK are welcome.

Thankfully
Biju Shankar

[Katerina Rudkovskaya [Stiltsoft] · Accepted solution]

Hi @Biju.Shankar,

You need to convert values to percentages to display them on the Y axis with the help of Table Transformer via SQL query like this:

SELECT T1.'column1',
 FORMATNUMBER(T1.'Feb'*100/(SELECT SUM(T1.'Feb') from T1)) + "%" AS 'Feb',
 FORMATNUMBER(T1.'Mar'*100/(SELECT SUM(T1.'Mar') from T1)) + "%" AS 'Mar',
 FORMATNUMBER(T1.'Apr'*100/(SELECT SUM(T1.'Apr') from T1)) + "%" AS 'Apr'
FROM T*

Please use Table Toobox to combine app macros in Confluence Cloud.

Create a chart and add percentages to the bars with the Show data labels option.

Here's the result you can reach:

Otherwise, you can only display values and percentages together via Show data labels on bars, but the Y-axis displays values.

 

[Danut M _StonikByte_ · Accepted solution]

Hi @Biju.Shankar,

Welcome to the Atlassian Community.

Are these charts/screenshots from Excel or from a plugin? Confluence does not offer charts like these out-of-the-box, so most likely you will need a plugin.

If you want to try a plugin, our Great Gadgets app for Confluence Cloud offers many macros that can be useful for this use case.   

For example, by using the Pivot Table & Pivot Chart macro you can display such charts with a few clicks. And the data will be in real time!

Here are some examples showing created tickets by type every month. But the gadget is highly configurable, so you can choose other fields (such as priority, severity, etc) or to format the dates in many other ways. 

Stacked Column Chart

Stacked Bar Chart

Table

Heat-map Table

Danut

[Biju.Shankar]

@Danut M _StonikByte_  @Katerina Rudkovskaya [Stiltsoft] that helps thank you both for sharing all the information in details.  Will play around and share my findings.

Thankfully 

Biju 

@Katerina Rudkovskaya [Stiltsoft]  @Danut M _StonikByte_ 

ASK / Question? = How to display the Y axis numbers in percentile %

Answer:

Yes I see the answers from @Katerina : -> You need to convert values to percentages to display them on the Y axis with the help of Table Transformer

Please use Table Toobox to combine app macros in Confluence Cloud.

In my companies Confluence page, I see Table Transformer options available, not the Table Toolbox ..

@Katerina Question : -> How should I get this options added to my companies confluence page ?
Answer :

@Danu Question -> Will Pivot Table & Pivot Chart macro have the options to display the Y axis numbers in percentile % ASK

Answer:

sharing the screenshots of current table chart with numbers on the Y axis  

ASK =display the Y axis numbers in percentile %

Pls reply at your convivences

Thank You,

Biju