Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft

Overview


Info

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 and Charts’ , 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:
Use the following SQL query:

Code Block
languagesql
SELECT *, 
"-" + 'Deleted Lines' AS 'Negative Deleted Lines' 
FROM T*
Chart from Table:
TypeColumn
Labels ColumnRepository Name
Values ColumnAdded Lines, Negative Deleted Lines
Handy Carousel