Custom column configuration

Overview

• You can customize a column of a widget by hovering on any column and clicking on the 🖊 icon. This guide will use the Table widget as an example.

• The Edit column popup will display. Each column type shall have different options.

• Click on the Format button to see further format options.

The default option is:

• No Prefix and Suffix

• 1,234.5 formation

• Decimal point: 0

• Comma, period

• Show thousands separator

• For Text type, it only has Column name & type, Prefix, and Suffix fields.

• For Date and Boolean types, they only have Column name & type field.

Column name

• Simply change the name of the column by typing in the Column name & type field.

Prefix and Suffix

• Continue to add Prefix or Suffix to the column.

Maximum character is 10.

Format

Preset

• Choose the Preset you want to display for the column.

Decimal places

• Click on the Decimal places and choose your desired option.

Separators and abbreviation

• For 1,234.5 formation, you can choose the separator option.

• You can do the same with the 12345 formation.

• For 1.2M, you can choose the abbreviation option.

Confirm your option

• Click the Done to confirm your option.

• To close the popup, click on the Cancel button, the X button on the top right, or simply click outside it.

• You can click the Reset button to revert your selection back to the previous save changes of the popup.

Your custom column setup will only apply to that column of the selected widget. It will not affect other widgets with the same data model.