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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Want to add values in columns in confluence

We want sum of all values in columns in confluence

is it possible to achieve ? Any plugin suggestion

32.JPG

in the last column(still need to add) the sum of all will appear

4 answers

2 accepted

3 votes
Answer accepted

We use Confluence Table Filter and Charts. 

This does not sum up the table cell values. But you have the opportunity to create a pivot table and sum up with this. Also this is a nice plugin for displaying charts createt out of the table. 

The question was asked before in this thread with multiple plugin suggestions:

https://community.atlassian.com/t5/Confluence-questions/Is-it-possible-to-perform-sum-calculation-in-a-confluence-table/qaq-p/189923

Hi @shetty

Table Filter macro has an option to output total column / row.

Dominic Lagger Community Leader Feb 26, 2019

Yeah thanks! I didn't know that, so was my answer :-) 

Like Zak Laughton likes this

Thanks i got total of columns.

 

i have one more doubt i.e.,can i use multiexcerpt plugin to get the total column to be displyed in other page as i see no option for column to edit

Like Zak Laughton likes this

It is possible to display the whole table with totals on another page only in the current version of Table Filter and Charts app. But there will appear a new Table Transformer macro that will allow to do this in the upcoming version 5.0. I'll post here later how to do this.

Like Zak Laughton likes this

we are using Jira cloud

It will be available in Cloud version as well.

Like Zak Laughton likes this

Apply Formulas(+,-,/) to different columns values to get another another column in confluence. Can some one help on this without any plugin. 

In general every team member on my team and our project managers are frustrated by the lack of spreadsheet like behavior in Confluence tables. One of the items I keep hearing about is project managers (PMs) and managers in general would like to track things in a spreadsheet.  They like jira but feel the need to have their own spreadsheet as well.  This is especially necessary as some managers of managers require such spreadsheets. 

I've endeavored to create some confluence tables that include jira items and yet allow the PMs to track other items.  However, tables in confluence are still very focused on showing static items, items from other pages, or data from jira; these tables are not good and combining table data and table calculations (other than column or row totals).   

Is there an ability to mix jira macros and formulas in Confluence tables that act more like spreadsheets?  Consider the table line below: 

spreadsheet+jira.png

I'm asking for a story like this:

As A: Project Manager

I Want: A Confluence table that combines my calculations and status of Jira issues (i.e a Confluence Spreadsheet).

So That: I can save time and reduce complexity by doing my own calculations in a single spot rather than using a mix Atlassian tools, spreadsheet tools..

 --Scott

Hi Scott,

You can wrap this table with the Tabe Transformer macro to add calculated columns. The SQL query will be similar to this one:

SELECT *, T1.'Column C' * T1.'Column D' * T1.'Column E' AS 'My result' FROM T1

where 'Column C / D / E' is the actual column name in your table.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

402 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you