Skip to main content
waffle.svg
Domo Knowledge Base

Table Chart

Version 28

 

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, two types of tables are available: standard tables and Heat Map Tables. These are almost the same; 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.

You can also create more powerful 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.

Training 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

 

 

Note: The product training videos are for Domo customers and clients only.

Unique properties of Tables include the following. Unless otherwise indicated, all properties apply to both standard Tables and Heat Map 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> 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.
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 > 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.

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 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 > 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.

Alignment > Column 1-16

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

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.

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

Training Video - Custom Table Sizing

 

 

Note: The product training videos are for Domo customers and clients only.

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.