Skip to main content
waffle.svg
Domo Knowledge Base

Properties for Tables

Important: When referencing this page outside of Knowledge Base, use this link: https://knowledge.domo.com?cid=tableproperties

Intro

Refer to this topic to find information about chart properties available for Tables, such as those for configuring header rows, total and subtotal rows, alignment, styling, and so on.

"General" Properties

The properties in the following table are found in the General category in Chart Properties.

Option

Description

Examples

Allow Text to Wrap

When enabled, text in Table columns wraps instead of disappearing off the right side of the column.

Text

Lets you set custom text for a Textbox. Any text you enter here replaces the text from your DataSet. You can use the macro %_VALUE here to insert the value from the column you applied in the Optional Value field. For example, if you wanted the text in your textbox to read "Today's quota is [some value]," you would enter Today's quota is %_VALUE in this field.

Font Style

Lets you choose whether the font for text in a Textbox is plain, bold, italic, or bold-italic.

Font Color

Lets you choose the color for text in a Textbox or Table.

Horizontal Text Alignment

Lets you select the horizontal alignment for text in a Textbox. The examples at right show the same string of text left-aligned, center-aligned, and right-aligned, in that order.

Vertical Text Alignment

Determines whether text in a Textbox appears at the top, in the center, or at the bottom.

Top Margin

Determines the amount of space in pixels above the text in a Textbox.

Bottom Margin 

Determines the amount of space in pixels below the text in a Textbox.

Left Margin 

Determines the amount of space in pixels to the left of the text in a Textbox.

Right Margin 

Determines the amount of space in pixels to the right of the text in a Textbox.

"Header Row" Properties

The properties in the following table are found in the Header Row category in Chart Properties.

Option

Description

Examples

Header Row Fill Color

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

Header Row Font Color

Lets you select the text color for the column names in your Table 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 Alignment

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

In the example, the column names are centered.

Header Row Font Style

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

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

"Total Row" Properties

The properties in the following table are found in the Total Row category in Chart Properties.

Important: Analytics functions (windows functions) are not supported in total or subtotal rows. 

Option

Description

Examples

Show Total Row

Lets you add a grand total row to the bottom of a 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.

Label

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

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.

Font Color

Lets you select the text color for the content in your Table's 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.

Font Style

Lets you select the font style for the column names in a Table 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" Properties

The properties in the following table are found in the Subtotal Row category in Chart Properties.

Important: Analytics functions (windows functions) are not supported in total or subtotal rows. 

Option

Description

Examples

Show Subtotal Rows

Lets you add subtotal rows after each group of like values in your Table's first column. In this 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.

Show as Percent of Total

When this box is checked, subtotals in a Table 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.

Label

Lets you customize the label text for your Table's 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.

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 in a Table. 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.

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.

Font Color

Lets you select the text color for the content in your Table's 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.

Font Style

Lets you select the font style for the text in your Table's 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" Properties

The properties in the following table are found in the Alignment category in Chart Properties.

Option

Description

Examples

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" Properties

The properties in the following table are found in the Attribute category in Chart Properties.

Option

Description

Examples

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.

 "Full Size Settings" Properties

The properties in the following table are found in the Full Size Settings category in Chart Properties.

Option

Description

Examples

Full Size Settings

Allows you to set custom sizing on tables in the card view when the "Full Size" option is selected—anywhere from 1 to 6 card sizes in both width and height. For more information about card sizing, see Changing the Size of Cards in a Page.

The first table in the example at right shows a table in the card view that has been set to a 4-card width by a 1-card height. The second table has been set to a 3-card width by a 3-card height.