Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
maxLevel3
minLevel2
absoluteUrltrue
excludeSee also
typeflat
separatorpipe

Overview

The metadata-calculate macro performs calculations using metadata values from matching pages.

The macro returns a single value by totalling up any float or integer metadata. This result can be shown directly or can be used as input to another statistics macro, such as the Confluence chartmacro.

This macro is most useful when presenting several totals in a single chart.

Parameters

Parameter

Required

Default

Notes

Version

value-name (first named parameter)


The list of fields (columns) to be included in the report. This can include added metadata and internal metadata.


function


sum

Specifies the function to apply to the matching data:

  • sum - returns the sum of each non-empty value (default)

  • average - returns the average of each non-empty value

  • maximum - returns the minimum of each non-empty value

  • minimum - returns the maximum of each non-empty value


key


current space

Limits the content returned to be within the space with the given key.


root


current page (@self)

Use @self for the current page (the default), @parent for the parent page, or the name of any page, e.g MySpace:MyPage.

If this is specified and the pages option is not, then the report will run over only the pages listed here.


label



Limits the content returned to be with specified label or labels.

A comma separated list produces ANY pages that match at least one of the listed labels. Using + operator for the list will return pages that match ALL the labels.

Parentheses can be used to build complex expressions

  • for example |label=policy, procedure)+hres| would return content with  hres and also has at least one of policy or procedure.


type



Specifies which Confluence content types should be considered for a report.

This feature was based on the Confluence contentbylabel macro which has the same attribute.


...

This is displays the retrieved metadata values:

...

Reference Markup

Code Block
languagetext
{metadata-calculate:Installs|key=CAI|root=InstallsSummary|label=jira_app|}

...