Intro
Most Domo chart types require certain columns from your DataSet to be built—usually columns with category, value, and series data. For more information, see the list of available Chart Types. However, with a table, you can include any DataSet columns and reorder them to suit your needs.- Table types
- Choose data to power your table
- Customize tables
- Understand row limits
- Interact with Table Charts
- FAQ
- Apply formatting, totals, and subtotals to Table Cards (video)
- Set a custom table size (video)
Table Types
There are several different types of tables you can use in cards. This table describes them.Table Type | Description |
|---|---|
Mega Table | Mega Tables can contain up to 100,000 (one hundred thousand) rows. If no limit is set in Analyzer, more rows can be added and scrolled through. When exporting a Mega Table, you can export up to 3,000,000 (three million) cells. For example, if there are 10 columns, 300,000 rows can be exported. If there are 30 columns, 100,000 rows can be exported. Mega Tables have expand/collapse and column sorting functionality, as well as Heatmap options, and can include functional URLs and images. Learn more about Mega Tables .
|
Pivot Table | Pivot Tables allow you to not only quickly summarize large quantities of data from a DataSet, but also explore data by different dimensions and measures. Pivot Tables can contain up to 100,000 rows, but by default will only load 10,000 rows. The hard export limit to Excel is 1,5000,000 (1.5 million) cells. With Pivot Tables, you can display data using both rows and columns. Each cell in the table contains data for the intersecting column and row. You can even have multiple columns and/or rows. Each subsequent column or row you add appears as a new grouping within the previously added grouping. Learn more about Pivot Tables .
|
Flex Table | Flex Tables display a different row for each series in a chart, with all series shown as individual Spark Line or Spark Bar charts. Information about each individual series is provided in the other columns in the table. By default, this information includes the series name and an indicator showing whether the series percent change is positive or negative, and the degree of change. However, in the table chart properties, you can change columns to reflect any of a variety of other aspects of the series, such as the minimum or maximum value in the chart the second-to-last value, or a change value (as opposed to a percentage). You can also add up to 10 additional columns to the table with this information. Learn more about Flex Tables .
|
HTML Table | These are basic tables that can contain up to 10,000 cells.
|
Heatmap Table | These are similar to HTML tables; however, in a Heatmap Table, values in a Heatmap Tables allow you to visualize relationships between data categories and draw attention to hot spots of activity and trends.
|
Choose Data to Power Your Table
As you design your table in Analyzer, you can drag any column from the DataSet into the Columns area above the chart to include it in the table. The columns display in the table in the order in which you arrange them in the Columns area, and you can drag them to rearrange as needed. In this example, theOrder ID column appears first in the Columns area, followed by Brand. This order is mirrored in the table.
- 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 aggregation, see Formatting Values in Your Chart.
Customize Tables
You can customize the appearance of a table by manipulating the chart properties. Learn about chart properties and table-specific chart properties.Specify Column Labels
To change the name of the column as it appears in the table, select the column field in the Columns area to expand the column menu. Enter your label text in the Data label field.
Format Individual Columns
You can use the column menu to customize the format for an individual column. The available formatting options depend on the column type. Follow these steps to access the formatting options:- In the Columns area, select a column to open the column menu.
-
Select Format.
- Justification — Choose how to justify column name and text.
- Text style — Choose from various text styles including bold and italic.
-
Display type — Choose the display type. The default is text. If you choose Image, Domo will try to convert the URL into an image. If you choose Link, Domo will convert that item into a link.
**For links, you can use the Prefix/Suffix fields to build a URL that is dynamic per row. You can also use the Label field to create a static label for the link.
- Date format (Each available date format has a preview. The Date shorthand and full date options take your locale into account when they are used.) For example, if your locale is Japan, a Japanese date format is automatically applied when you select one of these options. For a list of accepted date format specifiers, see Macros.
Table Calculations
Table calculations allow you to display a value in the table as a percent of a column total, part of a running total, or how it ranks against other values in the column without using Beast Mode calculations or DataFlows. You can bring the same column of data to the top of the chart multiple times to compare the calculated values side by side.
- Actual value (default) — Displays the values in the column as their actual values. This is the default setting.
- % of column total — Displays the values for each record as the percentage of the column total, with all values adding up to 100 percent.
- Running total — Displays the values for each record as the running total of values in the record, with the final count for all values in the column in the final record.
- Ranks large to small — Gives each record in the column a relative rank compared with all values in the DataSet from large to small.
- Ranks small to large — Gives each record in the column a relative rank compared with all values in the DataSet from small to large.
Configure Total and Subtotal Options for Individual Columns
In the column menus above your chart preview, you can configure options for total and subtotal cells for a given column.
Understand Row Limits
The maximum number of rows visible in a Table Card depends on the number of columns selected. See the table below for examples.| Number of columns selected | Number of visible rows |
|---|---|
| 1 | 5000 |
| 2 | 4999 |
| 3 | 3333 |
- If using Excel 2003, the limits are 65,536 rows and 256 columns.
- If using Excel 2007 or later, the limits are 1,048,576 rows and 16,384 columns.
Interact with Table Charts
Whether you publish your table on a dashboard or in an App Studio app, users can interact with tables in the following ways:Copy/Paste Values
Drag over values in the View Mode to copy those values for easy copy/paste.
Right-click to Filter
Right-click on a cell to filter on or exclude that value.
Right-click to Sort
Right-click on a column name to sort or filter on column values.
FAQ
Data in my table is missing or does not match the Summary Number.
Data in my table is missing or does not match the Summary Number.
Value1 column is 7, but your table has only 3 rows with values totaling 6. Why is there a difference?This is most likely due to the formatting of certain columns. If you have an aggregated column, every other non-aggregated column must have a “Group by” applied to it to get the correct result. If there are duplicate rows, they are omitted because of the grouping. However, the Summary Number doesn’t take these groupings into account, which is why the number is different.To align the values, you must separate the aggregated columns OR aggregate the column in the table that is the same column from which the Summary Number is derived.