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.

Overview №1

Macro combination:

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

Macro configuration:

Pivot Table:
Row LabelsRepository Name
Column LabelsState
Calculated Column-
Operation Type

Count

Chart from Table:
TypeStacked Column
Labels ColumnRepository Name
Values ColumnCount MERGED,
Count OPEN,
Count DECLINED

Overview №2

Macro combination:

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

Macro configuration:

Pivot Table:
Row LabelsAuthor Name
Column LabelsState
Calculated ColumnState
Operation Type

Count

Chart from Table:
TypeStacked Bar
Labels ColumnAuthor Name
Values ColumnCount MERGED,
Count OPEN,
Count DECLINED