Three rows of color sample chips in varying shades of blue and teal.

Conditional Formatting in Domo: Make a Colorful Data Table in 3 Easy Steps

Sarah Baker
,
Senior Business Intelligence Manager
,
May 12, 2021

Traditional data table formats can be overwhelming, but you can use Domo to call attention to the areas that require attention. Here’s how to build a colorful data table in 3 easy steps!

Back in early 2016, we wrote a post about how to use conditional formatting in Domo to apply colors to various cells in a table card.  But since 2016, Domo has made a lot of great updates to their product, and one of which is the introduction of color rules. In this post, we will show you how you can use some of the updated features in Domo to achieve the same results (including a colorful data table!), without having to deal with any HTML, CSS, or SQL.

Oftentimes, when a person is viewing data in a table format, it can be overwhelming to see rows upon rows of data, and people can struggle to be able to decipher which specific rows, columns, and/or cells require their attention.  We recommend using conditional formatting in Domo to help call attention to areas where the data is significant in terms of your company’s business conditions.

For an example, let’s use some basic Google Ads data and take this table from drab to fab with a few simple adjustments.

The first step in building a colorful data table in Domo using conditional formatting text.
Fig. 1: The basic data table in Domo

Step one for conditional formatting in Domo/ conditional formatting with colors:

Determine the metrics and the specific conditions for those metrics that users should focus on. In this example, let’s assume that the number of conversions is the key indicator of how successful a campaign has been. Specifically, we want to know anytime the number of conversions is less than 10 or greater than 200. We also want to see when the total number of clicks for a campaign is below average.

Step two for conditional formatting in Domo/ conditional formatting with colors:

Within your Domo table, navigate to the Color Rules section. You will see that within the color rules section, you can configure your table to display certain colors based on conditions for specific columns. Based on the conditions listed above, our color rules configuration would look like the below. This configuration will cause any rows to be highlighted in either red or green based on the value in the conversions column. This configuration will also cause the cells where the clicks are below average to be highlighted in blue.

The color rules modal: Conditional formatting text for conditional formatting in Domo
Fig. 2: The color rules modal
The results of conditional formatting with colors in Domo: A colorful data table
Fig. 3: The results

Step three for conditional formatting in Domo/ conditional formatting with colors:

After you enter in your logic for the color rules, you will notice that Domo gives you the option to apply those color rules to only the current card you are editing or to all cards. We recommend using the later option when the metrics you applied color rules to will be used on other cards on your dashboard.  Choosing this option will ensure you have standardized color rules applied to any instance where the condition is met, which makes for a more seamless user experience.

To summarize, within Domo, you can use the color rules in the following ways:

  • Set the color of an entire row based on the conditions of a specific column.
  • Set the color of a cell based on the conditions of a specific column.
  • Modify the table text or the text style of an entire row or a cell based on the conditions of a specific column.

Without doing any beast modes or knowing any HTML or CSS, you can take your table to the next level and easily highlight metrics that end-users should focus on.

As a Domo partner, Further enables companies to build end-to-end BI capabilities and achieve better insights from data. Reach out to learn more about how we can help!

Sarah Baker
,
Senior Business Intelligence Manager

For over 15 years, Sarah Baker has been working with clients to implement technical solutions that solve business problems. As a Data and Cloud Engineering Director at Further, Sarah aligns with client stakeholders and project teams to deliver best-in-class business intelligence and data warehouse solutions. Sarah also supports the Further team as a practice lead and mentor to her colleagues. In her free time, Sarah likes reading, walking her dog Norman, and playing Magic The Gathering.

,

Read More Insights From Our Team

View All

Take your company further. Unlock the power of data-driven decisions.

Go Further Today