Conditional formatting comparing values to another column

XMLWordPrintable

    • 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.

            Assignee:
            Unassigned
            Reporter:
            Tracy Chow
            Votes:
            4 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: