Data Grid

Check out the given walk-through on how to set the Data Grid chart properties.

Applying various Data Grid Properties to a View

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.

Default View with Grid chart

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.

Modified View after applying General Settings and View Filter chart properties

Please Note: The users get redirected to the pop-up color menu by clicking the Font Color or Background Color option.

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

Category Properties Provided for a dragged Dimension

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

Displaying a Measure Column with Dynamics Range colors

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.

Creating multiple Range for a Data Grid View

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

Measure Column reflecting multiple manually added Range

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.

Check out the illustration to understand the field re-ordering functionality for the Grid chart.

RE-ordering columns in the Grid Component