Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to add a report showing frequency of variable values in confluence?

Say I have a variable called "status" within a page template in Confluence, and the possible values for that variable are 0, 1 and 2...

How do I create a table which displays the number of pages holding each status in a parent page or ideally my space overview page:


Status         Frequency

0                  36

1                  79

2                  13




2 answers

0 votes
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Mar 19, 2019

Hello @lefras

Here is an idea how to implement it:

  1. Each page with status should contain Page Properties macro with a table: 2019-03-19_15h19_33.png
  2. Add Page Properties Report macro on the report page: 2019-03-19_15h21_26.png
  3. Wrap the report macro with pivot Table macro: 2019-03-19_15h27_02.png
  4. And as result you can create a chart: 2019-03-19_15h31_04.png
0 votes
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Mar 18, 2019

Hello there! Thanks for sharing with the Community.

Your project looks interesting! Currently there is no native way to implement global (or space wide) variables in Confluence. The closest thing we could do is using labels and user macros for this:

Is there a macro for displaying a label count? - Confluence Cloud

How to count the number of child pages with a particular label? - Confluence Server

We have had some customers who were looking to have something similar implemented! You can check it in this thread here:

Can I use variables across multiple Confluence pages?

Let us know if our threads help you out! Looking forward to your reply.

Hi Diego,

Has any progress been made on having a Variables ability with Confluence? 

Alternatively, a way to set up a Filter to accept parameters so that a Confluence page using a Filter macro retains the parameter values as a report? 

For example, a page showing a Filter macro to report on "Incidents last week", which lists the incidents which were created "last week", but then retains the dates of that week, so it can be used in an Automation to generate a weekly one. 

Or even an Alternative to that: saving the output of a Filter as the parameter/input for a Confluence Page (section/macro). 

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events