Use case
You need to choose a lighter status color.
Solution
- Switch the page to the edit mode.
- Insert the Status 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 *, CASE WHEN 'Employees' < 60 THEN FORMATWIKI("{status:colour=Green|subtle=true|title=Low}") WHEN 'Employees' >= 60 AND 'Employees' < 150 THEN FORMATWIKI("{status:colour=Yellow|subtle=true|title=Medium}") ELSE FORMATWIKI("{status:colour=Red|subtle=true|title=High}") END AS 'Status' FROM T1
- Click Next.
- Define the table settings and view options if needed.
Save the macro and the page.