Use case
You need to count the definite value in columns.
Solution
Switch the page to the edit mode.
Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.
Select the macro and click Edit.
In the Presets tab select Custom transformation and click Next.
Enter the following SQL query:
SELECT "Red mark" AS '', SUM(IF(T1.'Time' = "RED", 1, 0)) AS 'Time', SUM(IF(T1.'Quality' = "RED", 1, 0)) AS 'Quality', SUM(IF(T1.'Customer Satisfaction' = "RED", 1, 0)) AS 'Customer Satisfaction' FROM T1
Click Next.
Save the macro and the page.