Conditional formatting in Domo card

Vivarafa · 2023-10-17T18:34:06+00:00

There was an error rendering this rich post.

Team, raise my hand because I need to mimic the excel conditional formatting in a Domo card. If you do not mind, checking the enclosed jpg can check if the amount of the actual is lower that the estimated actual´s row turn to the color "red", but it vice versa, actual´s row is going to turn "green". I am trying the replicate the situation about card , which looks like the attachment

DOMO Current status.jpg

Do you have any idea to what path take to reach excel conditional formatting inside domo card

Find more posts tagged with

Accepted answers

ColemenWilson

You would use the color rules for the card.

Click "Colors" in the Chart Properties in card analyzer view
Choose the field that the conditional formatting will be applied to
Set the condition
Choose the color
Choose if you'd like it to be applied to the cell only or the entire row.

MarkSnodgrass

Since your estimated value is in a different row than your actual value, this isn't as easily done. You would need to be able to have your estimated and actual values in the same row and then create a beast mode to compare the two and then develop the color rule based on that.

All comments

ColemenWilson

You would use the color rules for the card.

Click "Colors" in the Chart Properties in card analyzer view
Choose the field that the conditional formatting will be applied to
Set the condition
Choose the color
Choose if you'd like it to be applied to the cell only or the entire row.

MarkSnodgrass

ColemenWilson

Thanks @MarkSnodgrass for pointing that piece out as well! Mark is right, the values you are comparing would need to be on the same row of data or in a beastmode that aggregates the data.

Vivarafa

Team , very sorry for my delayed response . I have checked the feedback from both, I feel frustrated owling to Domo for me , it´s almost everything in term of provide visual solution . Create actual and estimate in the same , it will change the entire lay out of my customer 's demand. Otherwise, I am going to testing by myself that path and come back with him and discuss the possibility if they have keep excel lay out, Domo is not the best option for replay.

Thank you