Table Transformer Macro - New Macro in Version 5.0

The Table Transformer macro is included in the bundle of useful macros for tables processing of the Table Filter and Charts for Confluence app in version 5.0.

The macro provides the ability to create a new table based on multiple tables in a few seconds:

- merge multiple tables (join rows from multiple tables to one table) using the default preset
- lookup multiple tables (join columns from multiple tables to one table) using the default preset
- perform any transformations: add complex formulas, match only specific rows (columns) using filtration criteria, output data using If/Then constructs, and much more using custom SQL queries

Try the app for free at the Atlassian Marketplace:

[finnmaccool]

I am using table excerpt, table excerpt include, chart from table and table filter macros.
The table has columns for Team, Date, Tasks, Time. I am using transformer to calculate tasks per minute, filtering Team, and Date columns, but the chart won't show the true tasks per minute as it just totals the column.
Any help would be appreciated.

[sockhymchhorn]

Thanks for ur video. I wonder how I can add more columns and put auto numbers. I mean add a column with calculated row numbering.