Conditional Formatting - table MoM

SamanthaC
SamanthaC Member
in Cards, Dashboards, Stories

Hello,
I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as red since there was a drop off) Photo attached of the table's current header set up:

Table MoM.PNG

The color rule conditions don't seem to be able to compare to other values in the table so I assume I need a beast mode I'm just not sure how to go about it.

Tagged:

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    You can't directly.

    • You could change your measure to be "change from prior month" instead of the raw value.
    • You could have that "change from prior month" as a separate value in the pivot table, and color-code that
    • A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:

    https://community-forums.domo.com/main/discussion/67883/pivot-table-coloring
    • Here's another example I posted that I think looks a little nicer:

    https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    You can't directly.

    • You could change your measure to be "change from prior month" instead of the raw value.
    • You could have that "change from prior month" as a separate value in the pivot table, and color-code that
    • A different approach I've used is concatenating an icon in the formula. I showed a (not particularly attractive) example in this post, though the formula you'll need in your case will be a bit harder:

    https://community-forums.domo.com/main/discussion/67883/pivot-table-coloring
    • Here's another example I posted that I think looks a little nicer:

    https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories