How to combine table transformer and pivot tables

[Andy Knott]

I have a table that is on a page which is using that table toolbox macro and has a table nested within table transformer macro which in turn is nested within a filter macro - so I can colour the rows based on condition and then filter the results to enable users to select data items which is of interest to them.

What Im wanting to do is additionally provide some charts that provide visuals on the status of data within that table, specifically I want to see a chart of open actions versus closed actions.

I get that there is a pivot macro that should be used before using a charting macro, but I'm just unclear how to structure the nesting, if at all, in order to have the pivot table based on the data in the table that is already wrapped in the table transformer macro

Can someone please provide guidanc on how to provide this level of depth of dependencies based on the use of a single table, or else make a suggestion as to an alternative approach that I could follow.

Cheers

[Andy Knott · Accepted solution]

I found an approach to this so I'm good

[Jason Caldwell]

Would you mind sharing? I am looking for something similar.

[Katerina Rudkovskaya [Stiltsoft]]

Hi @[deleted],

Sorry I haven’t come across the question earlier due to the weekend and time zones difference. Glad that you’ve found the solution yourself.

For other people who may come across this question: in Confluence Cloud you need to use the Table Toolbox macro to nest several macros (just drag’n’drop other macros inside its shell and create whatever sequences you want).

You may also reuse the source table with the help of the Table Excerpt/Table Excerpt Include macros and create several pivots, charts, transformed tables, etc. based on one source table (you’ll get a kind of a dashboard).

And if you are stuck with smth specific, you may always refer to our support. The portal is confidential, so you may share your source tables and macro settings, we’ll be happy to guide you through the difficulties.