Communardo Software GmbH, Kleiststraße 10 a, D-01129 Dresden

Analyze Page Metadata in Atlassian Confluence - with Table Filter and Charts add-on and Metadata for Confluence

In this guest blog post, we will outline how Metadata for Confluence works together with the Table Filter and Charts add-on to analyze page Metadata.

In this guest blog series, Vadim Rutkevich from StiltSoft takes a clo­ser look at what is pos­si­ble com­bi­ning their pro­ducts with our Metadata for Confluence add-on: Analysis, fil­tra­tion, and visua­liz­a­tion of page metadata. 


Atlassian Confluence pro­vi­des a rich set of capa­bi­li­ties for manage­ment of con­tent. Their approach to col­la­bo­ra­tive edi­t­ing, as well as exten­ded eco­sys­tem of add-ons, allows your team to quickly and easily achieve the defi­ned objectives.

Those people who use Confluence exten­si­vely use dif­fe­rent methods to cate­go­rize and struc­ture pages for quick acces­si­bi­lity and easy navi­ga­tion. Here's where page meta­data can help you with this.

By default, you can use the native Page Properties macro which allows you to spe­cify cus­tom key/value pairs for spe­ci­fic con­tent pages. This solu­tion allows you to keep meta­data wit­hin page con­tent. The Page Properties Report macro fur­ther pro­ces­ses labels of pages with meta­data and gene­ra­tes the index list of pages matching the defi­ned criteria.

But it is not per­fect. All the time you need to manu­ally enter text values and there is a high pro­ba­bi­lity that you can mis­s­pell some word or enter some­thing that will dif­fer from the ori­gi­nal value. And here you need a more data-consistent and com­pre­hen­sive solu­tion. Metadata for Confluence add-on from Communardo Software GmbH can become the solu­tion that can help you with get­ting con­trol over page metadata.

After expan­sion of con­tent in your Confluence, one day you may want to get insight into its struc­ture, and find out some cri­te­ria to clas­sify or cate­go­rize it. And Table Filter and Charts add-on from StiltSoft can become a solu­tion that will help you with con­tent fil­tra­tion, aggre­ga­tion, and visualization.

Sometimes you may want to get the aggre­ga­ted view of your page meta­data, and here the Pivot Table macro from Table Filter and Charts add-on will help you with this.

While edi­t­ing the page, enter '{Pivot Table}' and then move the Metadata Overview and Table Filter macros wit­hin it.

After saving the page, let's build a pivot table. Select the Addon Name as Row Labels, and Sprint Status as Column Labels. So here's the aggre­ga­ted view of sprints against the add-on and sprint status.

The next thing which we can do is a com­pa­ri­son of esti­ma­ted velo­city for all the clo­sed two-week sprints for dif­fe­rent add-ons. This will help us to get insight into team per­for­mance and look up for pos­si­ble impro­ve­ments in the deve­lo­p­ment process.

We re-build our pivot table and select the Addon Name column as Row Labels, change the cal­cu­la­ted column to Estimated Velocity, and switch to the Average, Min and Max operations.

As you may notice there are no signi­fi­cant devia­ti­ons in the esti­ma­ted velo­city bet­ween dif­fe­rent teams.


Author: Vadim Rutkevich, StiltSoft

>> Hier geht es zur deutsch­spra­chi­gen Fassung des Gastbeitrages.

13. April 2017

Pin It on Pinterest