Changing colors on a treemap

Reply
White Belt

Changing colors on a treemap

I have a set of server applications which I want to track the status on the dashboard.  Each application should have it's own square with a color associating with the status.  My data looks like the below:

 

app_name | status | color

app1          | ok       |  1

app2          | not ok |  3

app3          | warn   |  2

 

The only way I found to create equal sized squares for each app was to use a treemap with a calculated field with a static value. But I can't find a way to change the color of the squares based on the 'color' column.  I've attached an image of the dashboard I have so far in domo.  Please advise.  Thanks! 

Tags (1)

Accepted Solutions
Highlighted
Black Belt

The treemap doesn't really lend itself to doing that type of colorization. In addition to the HTML table, you might look into the Shape Chart, which is found under gauges. You would need to create a card for each app_name, but you could create a story page, or a collection and have them small and right next to each other. There a lot of shapes to choose from like thumbs up, thumbs down, etc. and you can apply different colors to different range of values. The end result would give you a very easy to view status page of your apps.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post


All Replies
Highlighted
Black Belt

instead of a treemap, could you use a table card and then use HTML tags to set the background of the cell?

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mo...


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Highlighted
Black Belt

The treemap doesn't really lend itself to doing that type of colorization. In addition to the HTML table, you might look into the Shape Chart, which is found under gauges. You would need to create a card for each app_name, but you could create a story page, or a collection and have them small and right next to each other. There a lot of shapes to choose from like thumbs up, thumbs down, etc. and you can apply different colors to different range of values. The end result would give you a very easy to view status page of your apps.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.