Query to sum colours from confluence tables

Matias G Labrana

Hello,

I would like to know if exist a way in table transformer (through SQL) to make a kind of sum of colors when the persons are coloring the table with the option of confluence (not by table transformer inside, as we would have to use HTML color codes). Let's suppose that:
- Green color = 3 pts

- Red color = 1 pts

- No color = 0 pts

Obviously we consider the sum from Column A till O in horizontal, so the result would be a new column next to Column O to reflect the final points.

Thanks!

Stiltsoft support

Hi @Matias G Labrana

Seems that you are using our Table Filter, Charts & Spreadsheets for Confluence app.

The Table Transformer macro indeed uses the AlaSQL library and treats the source table as a mini database (columns with specific names and values). If you don't have any values in your cells, there is nothing to work with.

Put "1" in your red cells, wrap the table into the Table Filter macro, and set the Total column to be calculated automatically - you'll get the number of red cells in a row. Or you may use the Table Spreadsheet macro and do the same in the Excel-like environment.