Adding Custom Javascript (Charts.js) to confluence page

[Albert Gil]

Hi all,

Currently trying to add custom charts to confluence page, however i would like the data in the table cells to link to my JIRA instance for dynamic data.

When i use the built in Insert JIRA Issue/Filter macro the resulting output in the table cell is not exactly a number i believe this is what is causing my charts not to render properly.

Pictured is an example of what i mean. (Cherries, Series 1)

Does anyone know of a work around for this issue? I've looked into user macros but not sure how to input JIRA filters are parameters for input.

I imagine if the "23 Issues" was changed to just "23" the chart would work fine as well.

Any help would be appreciated, thanks again.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Albert Gil ,

To remove "issues" from JIRA Issue/Filter macro, you can use the Table Transformer macro of the Table Filter and Charts for Confluence app.

Please wrap your table with it and use REPLACE() function in your SQL query:



By the way, our app also includes Chart from Table macro which allows you to create Radar chart as well.

But note that we have one month of a free trial.
Thus, you can  install the app with an evaluation license and "play" with all our macros.

Best regards,
Katerina