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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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
4,463,374
Community Members
 
Community Events
176
Community Groups

Average (AVG) number calculation from "Insert Jira Issue/Filter" (App) in Confluence.

Edited

We need a simple AVERAGE number to be displayed in confluence (extracted and calculated from a Jira issues list). This  AVERAGE number - unfortunately - cannot be extracted combining "Jira filters" (just results in issues/issue lists or issue counts), "Jira Chart" or "PivotTable" Apps, at least I am unsure about it because PivotTable tutorials do not work on tables generated with "Jira filters", do they?

"EazyBI" App does also not help to much either, since we do not search for a chart script, but just a plain AVERAGE number calculation (script) which "just" exists in Jira as dashboard gadget or report for certain periods of time, based on the CreatedDate and ResolvedDate issue properties, per calendar week/month/.../year. We need it for fiscal year calculations which do not fit the calendar year.

Any idea? Does "Table Filter and Charts for Confluence" (App) work with input from "Insert Jira Issue/Filter" as table? Any alternative available without "raw, more complex SQL queries"?

What are the alternatives to extract and calculate such/similar numbers?

Thanks a lot!

 

Related screenshots:

2021-08-03 10_36_26-Copy of Defect Management (19-05-2021) - Rainer Schiebenhoefer - HSM - Wiki — Mo.png2021-08-03 10_39_09-Copy of Defect Management (19-05-2021) - Rainer Schiebenhoefer - HSM - Wiki — Mo.png

3 answers

1 accepted

2 votes
Answer accepted

Hi @Rainer Schiebenhöfer ,

Yes, you can try the Table Filter and Charts for Confluence app in your case.
It works in the combination with the Jira Issue macro.

You can get the AVG number based on your table data with the Pivot Table macro and Table Filter.

Katerina
Stiltsoft

Thanks Katerina!

I will give it a try with the 30d-trail version (PivotTable app).

I will give it a trail, yes, but please allow the last two question then for now :-):

1. it is ok to nest PivotTable in a normal confluence table (I assume so) - right?

2. the "PivotTable" result will always be a table, right? I am Asking because I would prefer to just extract the calculated AVG number from that table, might be that the "PivotTable" display options allow for that in a way???

Note that the Pivot Table macro is not an app, and a macro included in the Table Filter and Charts for Confluence app.

1. Yes, you can insert the Pivot Table macro that outputs the table into the standard Confluence table.

2.Yes, it will be a table.

If you need help with the macro configuration or have further questions, please feel free to contact us.

Like Rainer Schiebenhöfer likes this
0 votes

Hi all!

As you mentioned the eazyBI, I wanted to add a little bit of what is possible with the app. 

You can specify how to calculate the average, also by using the Fiscal year (https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestoTimedimension).

Further, only one cell can be displayed with the calculation result in the table.

Even more nicely, this cell or some other additional 'only values' can be displayed in the Gauge chart only values view. See an example report here: https://eazybi.com/accounts/1000/dashboards/41359-kanban.

Lauma / support@eazybi.com

Improvement suggestion: if it is a one-cell table, just display the value, the „Pivot“. Extend the display options of this macro (if possible)

Thanks for the suggestion!

But, unfortunately, we won't support this case. It's not possible to implement.

Hi @Rainer Schiebenhöfer

I've added your idea to our backlog, and probably we'll find a solution, but a bit later, as we have more prioritized tasks for today.

Katerina
Stiltsoft

Hi @Rainer Schiebenhöfer,

The improvement has already been implemented, please update the app and use the Show result as plain text option in the Pivot Table macro.

image2022-8-19_12-23-10.png

Katerina
Stiltsoft

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events