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!


How to gather statistics across tables

Hi all. We have a migration project. We migrate knowledge across N applications. For each application, we've created a page with a checklist. The checklists are tables. Each table contains two columns and 50 rows. The row is a "key - value" pair with an appropriate application parameter. During a knowledge transfer, our teams have to fill those tables. We have data for the appropriate parameter if we have any data in the 'value' column. The KPI for the application is a percentage of filled rows. I have 2 questions:

1. How to calculate / get the number of rows where the 'value' is not empty? Having this we divide the number by 50 and we get the needed percentage.

2. If the first task has a solution, the second task is gathering those percentages across all application pages in one table.

Of course, using Excel/Google Sheets would simplify the task a lot. But I want to check Confluence-based possible solutions first.

I assume it's all about macros. I'd be grateful for relevant examples or guidance on what to read. Thank you in advance.

2 answers

3 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 14, 2023

Hi @Andrey Derenchenko,

It is not possible to implement your case natively, so you’ll need to browse the Atlassian Marketplace for some 3rd party apps.

For example, our company develops the Table Filter and Charts for Confluence app that will be handy for the case.

You’ll be able to count empty and not empty cells using the Table Transformer macro. After that you’ll be able to show the required percentage.

The Table Excerpt/Table Excerpt Include macros will help you to combine the result tables with percentage in an aggregated report on the master page.

If you are not familiar with the app, please book a live demo: will be able to discuss your case and possible solutions more thoroughly.

Hi @Andrey Dresvyannikov,


interesting and complex use case! But it sounds like Inline Table Editing for Confluence could solve that. With this solution, you can work in Confluence like in excel, even in view mode, and handle complex calculations. A list about all the built in formula and functions can be found in the documentation.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events