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

[Rainer Schiebenhöfer]

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:

[Katerina Rudkovskaya [Stiltsoft] · Accepted solution]

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

[Katerina Rudkovskaya [Stiltsoft]]

https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?tab=overview&hosting=cloud

https://docs.stiltsoft.com/display/TFAC/How+to+use+the+app+with+Jira+Issues

https://docs.stiltsoft.com/display/TFAC/How+to+use+Pivot+Table+macro

https://docs.stiltsoft.com/display/TFAC/How+to+use+Table+Filter+macro

[Rainer Schiebenhöfer]

Thanks Katerina!

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

[Rainer Schiebenhöfer]

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

[Katerina Rudkovskaya [Stiltsoft]]

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.

[Lauma Cīrule]

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

[Rainer Schiebenhöfer]

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

[Katerina Rudkovskaya [Stiltsoft]]

Thanks for the suggestion!

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

[Katerina Rudkovskaya [Stiltsoft]]

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

[Katerina Rudkovskaya [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.



Katerina
Stiltsoft