Simple dashboard using metadata-matches macro

1 Overview | 2 Creating the dashboard | 3 Related macros | 4 Related pages

Overview

A simple use of the metadata app is to add multiple versions of the metadata-matches macro to populate a table, creating a dashboard of information from a group of pages.

In our example, there are individual pages for a project. Each project page has:

An assigned project lead as a metadata value
The number of hours completed by the project lead for each month as a metadata value

Creating the dashboard

Three initial metadata-matches macros are used:

The metadata value name for the macro is Project Lead.
The Project Lead values for each metadata-matches macro are Alana, Hisbiscus, and Cyclamen

Metadata-matches macro body - added Project Lead value - Alana

Metadata-matches macro body - added Project Lead value - Hibiscus

Metadata-matches macro body - added Project Lead value - Cyclamen

Each individual macro displays, for the named project leader, the number of project pages where the Project Lead value matches their name.

A copy of each macro can be configured to add the metadata value-name for the calculation.

Metadata-matches macro body - added value-name=Feb Hours

This would sum the values of the Feb Hours metadata on the matching pages where Alana is the value for Project Lead.

For each project leader, a copy of each macro with the value name can be made, and the function option can be amended in the macro editor to show the average.

Metadata-matches macro body - added value-name=Feb Hours and function=average

These can be added to a simple Confluence table:

Confluence table with added metadata-matches macros

The page display is a simple dashboard for the project lead's hours for February.

Table with rendered metadata values for each project lead

Multiple versions of the metadata-matches macro can also be added to the Confluence chart macro to visualize and present the collated data from each report.