Skip to main content
waffle.svg
Domo Knowledge Base

Table Chart

Version 32

 

Intro

Most Domo chart types certain columns from your DataSet to be built, usually columns with category, value, and series data. With a table, however, you can include whichever DataSet columns in the table that you want. You can also change the order of the columns as desired.

For KPI cards in Domo, a number of different types of tables are available:

  • Standard tables. These are basic tables that can include up to 10,000 cells.  

  • Heat map tables. These are almost the same as standard tables; the only difference is that in a heat map table, values in a values column are given different shades of color according to where they fall in the given range. The following screenshot shows an example of a heat map table.

  • Mega tables (currently in BETA). These provide all of the same functionality as standard tables and heat map tables, but include much more as well. You can have up to 25,000 rows in a mega table. You can also collapse and expand, sort, and scroll mega tables on a page. Mega tables can also include HTML links and images.

All of the above tables are built in the same way and are discussed in this article. Domo also includes two more types of tables, which are discussed in their own topics:

  • Flex tables. These display different rows for each series of a graph, with all series depicted as individual Spark Line or Spark Bar graphs. For information about flex tables, see Flex Table.

  • Pivot tables (currently in BETA). These allow you to quickly and easily summarize large quantities of data from a DataSet as well as explore data by different dimensions and measures. For information about pivot tables, see Pivot Table - BETA.

You can also create pivot tables using Domo's Sumo card functionality. Sumo cards are not considered chart types for KPI cards as other kinds of tables, but belong to their own distinct class of cards. For more information about Sumo tables, see Sumo cards

For more information about chart types, see Available Chart Types.

For more information about the Analyzer, see Analyzer Layout.

For information about adding filters to your chart, see Adding Filters to Your Chart.

For information about configuring deep linking with filters in Table cards, see Page Analyzer Links.

Drill path works in tables as it does in other chart types. For more information, see Adding Drill Path to Your Chart.

Powering tables

Unlike other chart types in which you must drag columns of a specific data type into specific fields in the Columns region above the chart, you build tables by dragging columns into whichever Columns fields you want. The order in which you arrange the columns is the same order in which the columns appear in the table. So, for example, if you dragged the "Order Date" column into the first field, the "Customer Name" column into the second field, and the "Amount" column into the third field, the columns would appear in that order in the table. You can drag and drop column fields to rearrange them as necessary.

The following table shows the relationship between field order and table column order:

Columns still retain their unique data types after you have dropped them into a field. As with other chart types, you can click a column in the Columns region to access additional options such as aggregation, formatting, etc. The specific options that appear depend on the data type. Columns from the Categories region on the left side of the screen only allow you to set basic aggregation options and a Details > Table View label. Columns from the Values region provide more aggregation options, a label setting option, and number formatting options. For more information about aggregating, see Aggregating your data. For more information about formatting numbers, see Formatting Values in Your Chart.     

For information about value, category, and series data, see Understanding Chart Data.

In the Analyzer, you choose the columns containing the data for your Table. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.

For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.

Customizing Tables

You can customize the appearance of a Table in a number of ways. Many customizations are possible by setting Chart Properties. For information about all chart properties, see Chart Properties.

Videos - Table Formatting

Learn how to format your Domo tables by watching the following videos.

Adding Total and Subtotal Rows to Tables

When applying subtotals, there cannot be aggregations applied to the first column in your table.

 Applying Formatting to Tables

 

Unique properties of Tables include the following. Unless otherwise indicated, all properties apply to standard tables, heat map tables, and mega tables. You can click a thumbnail image to see a larger image.

Property

Description

Example

General > Font Color

Lets you change the font color used for all text in the table.

General > Allow Text to Wrap

When enabled, text will wrap in columns instead of disappearing off the right side of the column.

The screenshot shows an example of a standard Table in which text wrapping has been enabled.

General > Financial Style Negatives

When this box is checked, negative numbers are enclosed in parentheses; otherwise a minus sign is used.

General> Show Negative Numbers in Red

When this box is checked, negative numbers appear in red.

General > Set Column Widths

Lets you set the widths in pixels for all columns in the table as percentages. You do this by entering the widths as a comma-separated list.

In the example screenshot at right, the column widths were entered as 20,20,40,20

General > Number of Locked Columns (mega tables only)

Lets you determine how many columns on the left side of the table are locked. When columns are locked, they always appear in the table, even when scrolling to the right. 

General> Hide Columns

Lets you hide columns in a table by entering the numbers of those columns in a comma-separated list. Column numbers are based on the table column order going from left to right. For example, the third column from the left would be column 3.

General > Hide Alternating Row Colors (mega tables only)

Lets you turn off the default alternating row colors in the table, meaning all rows will appear with a white background (except for when you mouse over a column, in which case all cells in that column and the current row appear blue). 

General > Apply Color Rules to Totals and Subtotals (mega tables only)

Lets you apply any color rules you have set using the Colors property to total and subtotal rows in your table. 

General > Apply Color Rules to Headers (mega tables only)

Lets you apply any color rules you have set using the Colors property to header rows in your table. 

General > Allow HTML Links and Images (mega tables only)

Lets you permit HTML-encoded links and images to show up in your table.

URLs should be enclosed in <a> tags. For example, the following code would be converted into a functional email address for a user named "Sam MacGregor":

<a href="mailto: sam.macgregor@yankuna.com">sam.macgregor@yankuna.com </a> 

Images should be enclosed in <div> tags. For example, the following code would be converted into an image called "bruce.png" that is stored on knowledge.domo.com:

<div style="text-align:center"><img height="80px" src="https://knowledge.domo.com/@api/deki/files/7627/bruce.png?origin=mt-web"></div> 

The example shows a table in which both URLs and images have been enabled.

megatable_images_and_links.png

General > HTML Image Size (mega tables only)

Lets you set a size constraint for HTML images. You can set any size between 10 and 500 pixels. The default is 64. 

Header Row > Header Row Fill Color

Lets you select a background color for the header row in your table. If you select Default, no color is used.

Header Row > Header Row Font Color

Lets you select the text color for the column names in your header row. This color takes precedence over the table font color applied in General > Font Color, so if you set the general font color to blue and the header row font color to red, the header row font color would appear red instead of blue. If you then chose Default, the header row color would revert to blue.

Header Row > Header Row Alignment

Lets you select the alignment for the column names in the header row. The default setting is Left.

In the example, the column names are centered.

Header Row > Header Row Font Style

Lets you select the font style for the column names in the header row, either bold, italic, or bold-italic. The default setting is Bold.

In the example, Bold-Italic is set as the font style.

Total Row > Show Total Row

Lets you add a grand total row to the bottom of the table. In this row, all value columns are summed and all string and date/time columns are counted. Note that the label appears at the bottom of the first column, replacing any total information that would otherwise appear here, so it is recommended that you don't set a column you want to see a total of as your first column.

Total Row > Hide Counts (mega tables only)

Lets you hide "Count" summations for non-value columns in the total row. 

Total Row > Label

Lets you replace the "GRAND TOTAL" text in your total row with custom text. This option is only available when the Total Row > Show Total Row box is checked.

Total Row > Fill Color

Lets you select a background color for the total row in your table. If you select Default, no color is used. This option is only available when the Total Row > Show Total Row box is checked.

Total Row > Font Color

Lets you select the text color for the content in your total row. This color takes precedence over the table font color applied in General > Font Color, so if you set the general font color to blue and the total row font color to red, the total row font color would appear red instead of blue. If you then chose Default, the total row color would revert to blue. This option is only available when the Total Row > Show Total Row box is checked.

Total Row > Font Style

Lets you select the font style for the column names in the total row, either bold, italic, bold-italic, or underline. The default setting is Bold. This option is only available when the Total Row > Show Total Row box is checked.

In the example, Bold-Italic is set as the font style.

Total Row > Position (mega table only)

Lets you specify whether your total row appears at the end of the table (default) or at the beginning.

Total Row > Padding (mega table only)

Lets you add padding between the content in the total row and the upper border, in pixels. In the example, this value has been set to 25. 

megatable_total_row_padding.png

Subtotal Row > Show Subtotal Rows

Lets you add subtotal rows per group within the first column in your table. In the subtotal row, all value columns are summed and all string and date/time columns are counted.

In the example, the first column includes state names, which are sorted alphabetically. There are three rows for New Mexico. Therefore, a subtotal column appears after the New Mexico rows, providing subtotals just for the New Mexico data.

Subtotal Rows > Show All Group Names (mega table only)

When checked, for unaggregated data, names are shown for all individual items within a category. When unchecked, the category name is only used once (aside from the subtotal row), and blank cells appear under that name for all remaining values in the category. 

The first example shows a table in which the customer name appears every time a value is listed for that customer. The second example shows the same table with customer names only being listed once; all subsequent values for the customer have a blank customer name. 

megatable_groups_shown.png

megatable_groups_hidden.png

Subtotal Row > Subtotal Row Padding (mega table only)

Lets you add padding between the content in the subtotal rows and the lower border, in pixels. In the example, this value has been set to 25. 

megatable_subtotals_padding.png

Subtotal Row > Show as Percent of Total

When this box is checked, subtotals will appear as percent of total values for the entire column instead of the usual subtotals. This option is only available when the Subtotal Row > Show Subtotal Rows box is checked.

Subtotal Row > Hide Counts (mega tables only)

Lets you hide "Count" summations for non-value columns in subtotal rows. 

Subtotal Row > Label

Lets you customize the label text for your subtotal rows. Note that your custom text replaces only the word "Total," not the name of the group of like values the subtotal is based on. For example, if the group of like values was "Minnesota" and you added "Summary" as the label text, the label would read "Minnesota Summary." You can specify whether your custom label comes before or after the group name using the Subtotal Row > Label Position option.

This option is only available when the Subtotal Row > Show Subtotal Rows box is checked.

Subtotal Row > Label Position

Lets you specify whether the word "Total" (or your custom label if you specified one in the Subtotal Row> Label property) comes before or after the name of the group of like values the subtotal row is based on. The default is After. For example, if the group name was "Minnesota," by default the label would read "Minnesota Total." If you changed this setting to Before, the label would read "Total Minnesota." 

This option is only available when the Subtotal Row > Show Subtotal Rows box is checked.

Subtotal Row > Fill Color

Lets you select a background color for the subtotal rows in your table. If you select Default, no color is used. This option is only available when the Subtotal Rows > Show Subtotal Rows box is checked.

Subtotal Row > Font Color

Lets you select the text color for the content in your subtotal rows. This color takes precedence over the table font color applied in General > Font Color, so if you set the general font color to blue and the subtotal row font color to red, the subtotal row font color would appear red instead of blue. If you then chose Default, the subtotal row color would revert to blue. This option is only available when the Subtotal Rows > Show Subtotal Rows box is checked.

Subtotal Row > Font Style

Lets you select the font style for the text in the subtotal rows, either bold, italic, bold-italic, or underline. The default setting is Bold. This option is only available when the Subtotal Rows > Show Subtotal Rows box is checked.

In the example, Bold-Italic is set as the font style.

Subtotal Row > Position (mega table only)

Lets you specify whether your subtotal rows appear after the rows they apply to (default) or before.

Subtotal Row > Show Subheader Rows (mega table only)

Lets you add subheader rows above the groupings in your unaggregated data rows. If you intend to incorporate subheader rows in your table, it is recommended that you set them apart using the Subheader Fill ColorFont Color, and/or Font Style properties so users can see them easily. 

Subtotal Row > Subheader Fill Color (mega table only)

Lets you add a selected background color to your subheader rows. (Subheader rows must be turned on using the Subtotal Row > Show Subheader Rows checkbox for this to be available.) By default, no background color is used.

In the example, the subheader rows are shown with an orange background. 

megatable_subheaders_fill_color.png

Subtotal Row > Subheader Font Color (mega table only)

Lets you select a color for the text in your subheader rows. (Subheader rows must be turned on using the Subtotal Row > Show Subheader Rows checkbox for this to be available.) By default, the color is black.

In the example, the subheader rows are shown with red text. 

megatable_subheaders_font_color.png

Subtotal Row > Subheader Font Style (mega table only)

Lets you select a style (bold, italic, or both) to the text in your subheader rows. (Subheader rows must be turned on using the Subtotal Row > Show Subheader Rows​​​​​​​ checkbox for this to be available.) By default, no style is applied.

In the example, the subheader rows are shown in bold and italic styling. 

megatable_subheaders_font_style.png

Subtotal Row > Suppress Single Items Subtotals (mega table only)

Lets you determine whether to suppress (hide) subtotals if there is only one item in a group. 

Alignment > Column 1-16 (DEPRECATED)

Lets you set the text alignment (left, center, or right) for all desired columns in your table. Column numbers are based on the table column order going from left to right. For example, the third column from the left would be column 3.

In the example, all columns are set to Center.

Attribute > Column 1-16 (DEPRECATED)

Lets you set the font style (bold, italic, bold-italic, or underline) for all desired columns in your table. Note this does not affect text in header rows. Column numbers are based on the table column order going from left to right. For example, the third column from the left would be column 3.

In the example, the two value columns are set to Italic.

Theme > Theme (heat map tables only)

Allows you to change the color theme for the values column in a heat map table. For more information about setting colors, see Changing the Default Colors in Your Chart

Scale > Use Log Scale (heat map tables only)

Uses a logarithmic scale for the ranges in a heat map table.

 —

Scale > Independent Column Ranges (heat map tables only)

Causes ranges to be applied separately to each column in a heat map table.

Heat Map Options > Color as Heat Map (mega tables only)

Lets you apply heat map coloring to the value cells in your table. Lighter or darker shades are applied depending on where a particular value falls in the entire range of values present in a given column or in the entire chart (depending on the settings of other Heat Map Options properties). 

megatable_heatmap_coloring.png

Heat Map Options > Theme (mega tables only)

Allows you to change the color theme used when heat map coloring is turned on in your table. For more information about setting colors, see Changing the Default Colors in Your Chart.

Heat Map Options > Independent Column Ranges (mega tables only)

Allows you to specify whether heat map coloring for columns is based on the entire range of values found in the table (unchecked/default) or if each column's range of values is deemed to be separate from the others. 

Heat Map Options > Apply Heat Map to Columns (mega tables only)

Lets you specify which numeric columns in your table have heat map coloring. You indicate the columns by their number in the table from left to right. You can use commas to indicate different columns or hyphens to indicate ranges of columns. For example, if you entered 2,4-6 in this field, columns 2, 4, 5, and 6 would have heat map coloring. 

Heat Map Options > Use Log Scale (mega tables only)

Uses a logarithmic scale for heat map ranges.

Specifying Column Labels

You can change the label that appears for any column in your table.

To change a column label,

  1. Click the column field in the Column region above the chart.

  2. Enter the desired label into the Label field.

Setting Formatting for Individual Columns

In the column dropdowns above your chart preview, you can specify formatting for individual columns. Formatting you can customize includes the following:

  • Justification. You can choose left, center, or right justification for the text in a column.

  • Style. You can choose regular, bold, italic, or bold-italic text styling.

  • Display As. You can choose whether numerical values display as plain numbers (default), currency, or percentage values. If you choose Currency, you can select from four commonly used currency symbols, the number of decimal places, and whether a thousands separator is used. If you choose Percenage, you can specify the number of decimal places, whether to multiply values by 100, and whether a thousands separator is used.

To set formatting for a column,

  1. Click the column field in the Column region above the chart.

  2. Click Format.

  3. Set options as described above.

Setting Total and Subtotal Options for Individual Columns

In the column dropdowns above your chart preview, you can specify options for total and subtotal cells for a given column. Options you can set include the following:

  • Calculation. You can choose how the values in your selected column are calculated to yield total and/or subtotal values. By default, the values are summed. You can also choose from Minimum (which takes the lowest value from the column), Maximum (which takes the highest value), Average (which averages all of the values in the column), and Count (which counts the number of values in the column).

  • Hide Subtotal. When you check this box, the cells for this column in all subtotal rows are left blank.

  • Show Subtotal as Percent of Total. When you check this box, subtotals display as a percent of the column's total.

  • Hide Total.  When you check this box, the cells for this column in all total rows are left blank.

Note: If you are using Beast Mode calculations in your Table card which contain either COUNT(DISTINCT ), SUM(DISTINCT ), or division calculations, the subtotal/total rows will not necessarily match the SUM of those same values in the card for that Beast Mode column. This is because Beast Mode calculations are applied on a row-by-row basis, whereas  subtotal rows are calculated on the entire grouping and total rows are based on the DataSet as a whole.

ashley_grand_total_grouping.png

ashley_grouping_based_on_category.png

ashley_subtotals.png



 

To set total and subtotal options for a column,

  1. Click the column field in the Column region above the chart.

  2. Click Subtotal/Total.

  3. Set options as described above.

Setting a Custom Table Size

Video - Custom Table Sizing

 

For more information about custom sizing of charts, see Changing the Size of Cards in a Page.

Understanding Row Limits

The maximum number of rows visible in a Table card depends on how many columns are selected:

Number of columns selected Number of visible rows
1 5000
2 4999
3 3333

Your version of Excel can also limit how many rows and columns you can import from Domo. 

  • If you are using Excel 2003, the limits are 65,536 rows and 256 columns. 

  • If you are using Excel 2007 or later, the limits are 1,048,576 rows and 16,384 columns. 

Excel cannot handle more than 1,048,576 rows and 16,384 columns. This is the maximum you can have in a worksheet, whether it be Excel or CSV data.

If an export from Domo exceeds the number of rows above, then not all of your data will transfer in Excel. This is a limitation that Excel has set. Regardless of the limits that are set within Excel, Domo will export everything that you have, no matter the row size. It is then up to you to find the program that will allow you to open or view that data.

FAQs

Data in my table is missing or does not match the summary number.

For example, you may have a card in which the summary number for the sum of the "Value1" column is 7. In your table, however, there are only 3 rows, with values adding up to 6. Why the difference? 

The reason is most likely due to the formatting of certain columns. If you have one aggregated column, every other unaggregated column must have a "Group by" applied to get the correct result. If there are any duplicated rows, they are omitted because of the grouping. However, the summary number does not take these groupings into account, which is why the number is different. To line the values up, you will need to unaggregate the aggregated columns OR aggregate the column in the table that is the same column the summary number is derived from. 

What is the maximum number of columns I can add to my table?

The maximum number of columns you can add to a table card is 100.