Stats On Supplier
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 |
|---|---|---|---|
"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