-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Chart - Settings
-
None
User Problem
I would like to add conditional formatting on my Atlassian Analytics table chart where if Column A's value is different than Column B's value, then format the cell red. But if the two column values are the same, then format the cell green.
Suggested Solutions
Add the ability to set conditional formatting where the condition compares the column's values to another column.
Current Workarounds
Compare the two columns in Visual SQL, for example by adding an "Apply Formula" step with CASE statement:
CASE WHEN "Column A" = "Column B" THEN 1 ELSE 0 END
Then the conditional formatting can be set via this new column.