Is there any way to create a Stacked Bar chart based on the results of a Two Dimensional Statistic Macro? I can get the Bar chart to work off a manual table with the Chart macro, but when I replace the table with the Two dimensional Filter Statistics Macro, it doesn't work.
We have added macro into our environment to test. I add one of the macros (table filter foe example) and save. Once this appears in my editor, I add my JIRA Two Dimensional Table Macro inside the table filter macro and save. When I open the Table Filter Macro again, it generates the following error message:
"Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro."
How do I attach my data source?
Thanks for the help - that worked.
Now I'm struggling with the Pie chart. I tried inserting a two dimensional table with the summary I wanted, but the generated pie chart includes the total row - not what I'm after. I then tried inserting the JIRA data using the Insert JIRA Issue/Filter, but the pie chart doesn't generate correctly. Any ideas?
I used Table Filter to filter out the total row:
I used the Table Toolbox macro to combine Table Filter and Chart from Table in the new editor:
I case you need to show count of each status using Jira Issues macro, then you need to use Pivot Table to count statuses:
Thanks for your help - this is working as expected. I have a question with regard to the Table Filter. Where one of the colums is a JIRA issue (//JIRA then type in the key and display as a single issue), this appears correctly in the table after the first edit. If I then republish the table it will display the URL rather than the single issue view.
Is there any way to ensure that this display correctly - ie the single issue and not the URL?
This is a known issue. It comes from the fact that Confluence renders those links incorrectly for the app as well as for the PDF export. As soon as it will be fixed for the page export to PDF, it will be shown correctly inside the macro. Notice that it works correctly in the legacy editor.
Is there any way I can set the colour of a cell in the table based on its value? As an example we have a RAG status that can be Red, Amber or Green and I'd like the cell in the table to have this colour.
I did try to use the Table Processor where I created a second table with the correct colouring and used the Lookup Tables component of the Table Transformer. I got this to work, but now have two columns in my table with the RAG status (the original extracted from Jira and the correctly coloured one from my query. Hiding the original field in the table filter results in no records returned.
Can you help?
Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...
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