How to navigate to jira by clicking on any cell from Pivot table created from Jira Issue in Confluen

[alex vincent]

I have created issue in JIRA. Post which, in the confluence page, I have inserted the issue and have used Pivot table on top of that.

The pivot table with Jira issues works fine. I would like to know if I click on any one of the value in pivot, then confluence should display all those issue corresponding to it by redirecting to JIRA. Like we have in excel where in once we have created a pivot table, post which on clicking on any of the cell in the result a new sheet is opened which will have result corresponding to the clicked cell.

Thanks a lot.

[Katerina Kovriga {Stiltsoft}]

Hi @alex vincent ,

You can see the precise results from the source Jira Issues table when clicking on the corresponding sectors/bars of the charts based on your pivot tables.

Please see the two screenshots with my comments attached below:

P.S. I assumed that you are using our Table Filter and Charts for Confluence app and its Pivot Table macro.

[MOh G]

@Katerina Kovriga {Stiltsoft} 

Suppose I just want the link to the Jira link issues. I.e: the part that says XX issues with a link where I could click on it and go to Jira, not the whole list.

[MOh G]

I think I might have a workaround. Add two Jira issues. Make one as a table to feed data and one as totals only (and show it)  Put both under a filter that takes parameters from the chart selections.

Question: would a stacked Bar selection still feed to the filtered table?

[Katerina Kovriga {Stiltsoft}]

Hi @MOh G ,

I'm sorry, I'm out of the office for the next two weeks. 

Please raise a support ticket for the case.