Column Formatting

In ViewZen Analytics, column formatting refers to the ability to customize the appearance and structure of header, data and footer displayed in columns within a grid or table.

In ViewZen Analytics, the following column formatting options are available

Text

These settings only apply to text fields. Following properties can be set

• Wrap - If enabled, long text strings can be wrapped within a given space to avoid overflow or truncation.

• Length -This prooperty can be used to set a maximum character limit for the text.

• Word Break - If enabled, this option allows long words to be broken and continued on the next line.

Text Align

Text alignment refers to the positioning of the text within a column or cell in a grid or table. Text can be aligned in various ways depending on the type of data. The following alignment options are supported

• Left Alignment: Text is aligned to the left side of the column or cell. This is commonly used for text-based data, such as names, descriptions, or labels.

• Center Alignment: Text is centered within the column or cell. Center alignment is often used for headers, titles, or numeric data that should appear equally balanced.

• Right Alignment: Text is aligned to the right side of the column or cell. This alignment is typically used for numeric data, such as monetary values, percentages, or quantities, ensuring that the numbers align neatly for easier comparison.

Label Settings

• The font type, size, text color and background color of the header, footer text or the value.

• Text formatting options like bold, italics, and underline can be applied to the of the header, footer text or the value.

Formatting

Numeric Data

Various formats can be applied to the header, footer text and the values.

• Display Formats

  • Number - Number fields can be displayed in one of the following formats

    • Crores

    • Lakhs

    • Thousands

    • Billion

    • Million

    • Indian NS (with Suffix)

    • Western NS (with Suffix)

    • Indian NS (with separator)

    • Western NS (with separator)

    • Percentage

    • Currency - The currency of the selected country.

    • Finance

    • Accounting - The accounting year of the selected country.

    • Decimals - Decimals settings allow users to control the number of decimal places displayed in numerical values. E.g., 0 for whole numbers, 2 for 2 digits after decimal.

    • Prefix - The Prefix setting allows users to add a predefined text or symbol before numerical values in axis labels.

    • Suffix - The Suffix setting allows users to add a predefined text or symbol after numerical values in axis labels.

Time based Data

One of the pre-configured formats can be selected or a custom data format can be determined.

Text Data

These formatting options don't apply to text data.

Column Width

Can be used to set a fixed width for the column in pixels. By default, all columns will have an equal width.

Apply To

Apply To provides the option to apply the setting to either the Header Text or the Footer Text or the Value.

Column Formatting