I want to create a table view of ticket items we are taking in to PI.

[jennie_thrift]

I want to create a table view of ticket items we are taking in to PI. I can't figure out the correct macro to use but I want to have a confluence page with a 'source table' at the bottom that lists all our PI tickets against the team they are assigned to. I then want to have a table above that pulls the ticket information from Jira and combines it with the assigned team information from my 'source table'. I have seen this done before but can't figure out how to do it myself.

[Stiltsoft support · Accepted solution]

Hi @jennie_thrift ,

If you have the Table Filter, Charts & Spreadsheets for Confluence app (that is our add-on), you may use the Table Transformer macro to combine the Jira Issues table with a manually created one. Here is an example from our documentation.

And if you prefer Excel-like style of working, you may turn your Jira Issues in a spreadsheet using the Spreadsheet from Table macro and add the required data manually in the correspondent cells.