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

Summarize custom field from jql Jira-Table and show result on confluence page

Hi all,

 

I try to find a solution to include a summary table on top of a confluence page. 

Somewhere on the page I have a Jira table query which show's me a list of Jira issues. 

On top of the page I would like to have a confluence table which summaries the values from one custom field from all issues of the included table. 

 

I did not find a solution to sum up the value of all fields and include the result not at the end of the table rather as data field somewhere on the confluence page. (detached from the table)

 

In addition is there a possibility to calculate in such a summary new values?

 

Did somebody have an idea or solution to this problem.

Thanks a lot.

1 answer

Hi @Sigurd Schacht ,

As far as I know, there are no built-in macros that can help you.

You can use the macros bundled in the Table Filter and Charts for Confluence app.

The Table Excerpt and Table Excerpt Include macros will help you to display your table at the top of the page (you don't need to maintain two tables, because the included table is a dynamic copy of the excerpted source table).

2019-11-06_16h32_58.png

After that, you can wrap the included table in the Pivot Table or Table Transformer macros to perform calculations.

2019-11-06_16h36_45.png

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...

415 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