Data Grid

The users can see data in tabular format by selecting the Data Grid component from the chart list. Multiple values can be displayed via Grid visualization.

Properties

General Settings

• Order: Users can order the displayed data by selecting an option from the given choices:

  • Ascending

  • Descending

  • None

  • Manual Sort (Users can manually sort the dimensions using the indicator signs).

    • By selecting an order, the user needs to configure the following fields:

      • Order By- Select a value option from the drop-down menu to order the data sequence.

      • Limit- Set a number to display the requested information by this limit.

• Font Size: Select a font size from the given choices (Small, Medium, Large).

• Bold: Use a checkmark in the box to display the fonts of the heading in Bold.

• Italics: Use a checkmark in the box to apply the Italics style to display the heading.

• Underline: Use a checkmark in the box to underline the headings of the displayed data columns.

• Font Color: Select a font color using the menu.

• Background Color: Select a background color using the menu.

• Exclude from Global Filter: Use a checkmark in the given box to exclude the view from the Global filter condition.

View Filter

• Filter: Select a filter condition from the drop-down menu.

Category Properties of Grid

The user can set the width of each column by configuring it from the Category Properties (for Dimensions) and Series Properties (for Measures) in the Data Grid.

• Click the icon given for a Dimension to open the Category Properties for dragged Dimensions.

• The user can modify the following information for a dragged Dimension.

  • Display Name

  • Column Width

Series (Measure) Properties of Grid

• Click the icon given for a Measure to open the Series Properties for a dragged Measures.

• The following properties can be modified for a dragged Measure:

  • Aggregation

  • Display Name

  • Column Width

  • Column Format

  • Number format

  • Alert Options

    • Show Alert

    • Show Alert Labels

    • Font Color

    • Dynamic Range

      • Min Color

      • Max Color

Manual Ranges

The user can also set Ranges and their colors manually. The manually set range will be displayed if Dynamic Range is not selected.

• Click the Add icon to insert a new Range.

• Provide Maximum and Minimum values for the newly added Range.

• The column will reflect the inserted range of colors based on the values.

Re-ordering of Fields in the Grid

We now support the re-ordering of fields in the Data Grid chart. By allowing field re-ordering, users can present their data in a more logical and meaningful way, improving the overall clarity and usability of the Data Grid chart.