Overview

Awesome Graphs for Bitbucket gives you the capability to export raw data with the statistics across all projects and repositories to a CSV file by using the Export to CSV feature. As a result, you will get the list of the commits or pull requests made during the selected time span with their details.

The resulting CSV file can be further exported into Confluence and transformed into a table using Table Filter, Charts & Spreadsheets' Table from CSV macro .

Macro combination:

  1. Insert the Table from CSV macro.
  2. Wrap the Table from CSV macro in the Table Transformer macro.
  3. Wrap the Table Transformer macro in the Chart from Table macro.

Macro configuration:

Table Transformer:

SQL Query

SELECT 'Created Date',
AVG('Cycle Time Total') / 86400 as 'Average Cycle Time'
FROM (
SELECT *, FORMATDATE(T1.'Created Date'::Date, "yy-M") 'Created Date' FROM T1)
GROUP BY 'Created Date'
CODE

Settings:


Date format

yy-mm-ddThh:mm:ss

Chart from Table:

Type

Time Line

Dates Column

Created Date

Values Column

Average Cycle Time

Date Format

yy-M

Show Grid

✔

Interpolation

Natural cubic

Show Trendline

✔