Stats On Supplier

Owned by Robert Alexander Marshall
Last updated: Oct 17, 2023 by Robert Alexander Marshall
2 min read
1 Overview | 2 Details | 3 Supported Keys | 4 Examples

Overview

Performs basic statistical analysis on values in a Collection of items.

This supplier takes a quoted keychain which will usually point to a number, date, or other 'comparable' value, and processes each item. This results in a Stats report that lets you access the results, such as the sum, average, min, max, etc. Also, see the grouping-reporter macro for more complex options.

Details

Name:

Stats On Supplier

Prefix:

stats-on(required)

Supported Content:

Anything, but Collections will be the most effective.

Provided By:

Reporting for Confluence FROM v3.2.0

Supported Keys

List of keys that this supplier returns a value for.

Key

Content Types

Return Type

Description

Key

Content Types

Return Type

Description

"prefix:key > prefix:key"

Anything

Stats

The quoted keychain to perform analysis on.

This should point to a single value, typically a number, date, or other 'comparable' value.

Examples

Average Versions Per Page

Outputs the average number of versions for each child page of the parent page.

Instructions

  • create a Report Info macro

  • insert the following for the Key parameter

    • page:children > stats-on:"page:version history > collection:size" > stats:value average

  • insert a parent page for the Source parameter

In our example, we used the List of Suppliers page.

Result

List of Suppliers: 5.761904761904762

Things to Note

  • the example started with a collection - page:children

  • "page:version history > collection:size" is in quotes

Quotes are used so that that 'stats' keychain gets passed into the 'stats-on' supplier, and does not become part of the main keychain.

  • after the stats-on section

    • we continue to the Stats Supplier to retrieve the value we're after