Automatic value in Confluence, gernerated by Jira, how to transport it in Confluence

[Michael Strickler]

Hello everyone

We are working with Confluence and Jira together.

In Confluence, our intranet tool, we would like to show in a table a field with the value "Average resolution time in days" for a project and a period.
We have a filter in Jira and we are using the gadget "Resolution Time Gadget" in Jira on a Dashboard. This gadget provides us the amount of Average resolution time in days for a project and a period.
However, this value is in Jira in the gadget "Resolution Time Gadget" in the table when you enlarge the gadget. However we need it in Confluence in a field.

Do you have any solution for this challenge? How we can proceed this?

Eventually we have to do a selfmade macro in Confluence and connect to the database of Jira with a select-statement on the jira-database (the value of the gadget "Resolution Time Gadget" in Jira is not counted, it is stored in a database). Would it be possible like this?

Thank you for answering us.

Kind regards.

Michael Strickler