Aggregation & Graphing Solution

[Rob Hearne]

Hi,

I am looking for a solution (s) that will support the following setup & requirements:

Setup

• One page per customer using a table to track issues, status & ownership & outcome

Requirement

• Solution that will automatically centralise this into one location (Did try using Page Properties & Page Properties Report, somewhat unsuccessfully)
• From this centralized location ability to have standard excel-like functionality to filter on table
• Ability to implement Excel pivot table functionality.
• Ability to present metrics in visualizations, with filtering functionality.

Thanks in advance for suggestions.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Rob Hearne,

Seems like our Table Filter and Charts for Confluence app will fulfill your needs.

The Table Excerpt/Table Excerpt Include macros will help you to collect tables and combine your big master report. The Pivot Table, Table Filter  and Chart from Table macros will enhance your master table with Excel-like functionality. You may check our documentation for reference.
We’ll be happy to organize a live demo for you and your team – please book a suitable time slot here.

[Rob Hearne]

Thanks @Katerina Rudkovskaya _Stiltsoft_, This does majority of what I was looking for. Will play around a bit more to become more familiar with it, but so far so good. Thank you

[Rob Hearne]

Hi @Katerina Rudkovskaya _Stiltsoft_ Can you confirm these come as standard with the Data Centre solution, which we will soon migrate to ?

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Rob Hearne, 

Table Filter and Charts for Confluence is an app for Confluence from the Atlassian Marketplace. It exists both in Server and Data Center Confluence versions. You can try using it for a month for free and book a suitable time slot here to get a live demo and ask any questions. 

[Rob Hearne]

[Rob Hearne]

So what I dont see supported in Confluence is this Pivot table filtering capability. However I'm be surprised it I wasn't the first to ask about this functionality.

[Rob Hearne]

Thanks Brant,

My use case is as follows:

 - Record customer issues relating to upgrades, assigning a code based on the outcome of each issue.
 - The plan is to use a page per customer to record this.
- Roll this up into a central location, from where I can calculate a range of different metrics & KPIs.
- These metrics will vary, with some applied across all upgrades, while others will be customer-centric.
- I want ability to present these metrics in Excel type pivot tables.
Hope that sheds some light on what I ma trying to achieve here.

Regards

[Brant Schroeder]

@Rob Hearne 

The functionality you are describing is not native to Confluence.  You would need to checkout the Atlassian marketplace and see if there is a third party application that provides that functionality.  I am not aware of any.  If you would like to share your business case and what you are trying to do there might be other solutions in Confluence that will meet the need or come close.