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

How to gather statistics across tables

Andrey Derenchenko November 13, 2023

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_
Atlassian Partner
November 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.

0 votes
Patricia Modispacher _appanvil_
Atlassian Partner
November 16, 2023

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
DEPLOYMENT TYPE
CLOUD
TAGS
atlassian, atlassian community events, ace, engineering, confluence feed, power of feed, atlassian ask me anything, atlassian confluence answers, ace rsvp, atlassian community events rsvp, atlassian magic

“How We Built This” ft. Atlassian Confluence Engineers

Meet the engineers who are making the Confluence magic happen at Atlassian ✨

RSVP now!
AUG Leaders

Upcoming Confluence Events