How to customize columns in JIRA chart macro?

[Stella Wong]

I've created a 2-dimension JIRA chart with labels as the x-axis.   However, I would only like the labels which I care about to show up in the columns instead of all labels tagged to the JIRA.   Is there a way to customize it?  

[Katerina Kovriga _Stiltsoft_]

Hi @Stella Wong ,

You may try the Table Filter and Charts for Confluence app. Wrap your Jira Charts macro in the Table Filter macro and hide the columns that your don't want to see.

Here is an example of our Jira Chart:

I use statuses instead of labels, but it is just an example - we simply don't use enough labels to illustrate the case.

So, let us pay attention only on the IN PROGRESS and DONE statuses and hide the unnecessary ones:

Hope it helps.

[Stella Wong]

This worked, but is there a way to choose only the columns I wanted instead?   I want to see only the labels which I've created, but because other users are adding their own labels my table keeps dynamically changing.   Any idea how I can fix this?

[Katerina Kovriga _Stiltsoft_]

You'll need to use the Table Transformer macro instead of the Table Filter macro.

Wrap your Jira Chart into the Table Transformer macro, choose the Custom transformation, go to the SQL query tab and paste the following:

SELECT T1.'Assignee', T1.'Status Done' FROM T*

This is an example for my table from the previous screenshots to show only Assignee and Done column.

You need to select your own columns that you want to show. Type in T1. and you'll get a pop-up with all available columns of your table to choose from.