Hey Gerry -
A few steps for this:
1. Create your condition in a formula with some if statements.
2. Create a dummy field with just the number 1 as its formula
3. Then drag the condition to color, and the dummy field to size.
4. The dummy field should be a min or max or average, NOT sum
5. Max out your size shelf, this will have it fill the entire row
6. Adjust colors to you what you need
7. Format labels to align, and what not
You get something that looks like the attached all based on a condition. Basically a conditional highlight table. It can even be driven by parameters if need be.
Conditional highlight table.PNG 26.8 KB
Thanks very much for responding here really appreciated.
On step 1 I do not know how to approach creating an IF statement for my required request:
-For individual 'test name' rows I would like to 'colour' if:
-the KPI (Actual) metric is lower for the test group vs the control group when KPI='CPA'
-the KPI (Actual) metric is higher for the test group vs the control group when KPI='CTR'
Please could you let me know what this formula would look like.