Data Grid

Data Grid

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

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 by 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 sequence of the data

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

• Font Size: Select a font size out of 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.

Properties tab for the Grid charting type

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

Category and Series Properties of Grid Chart

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.

• Navigate to a view displaying data in the Data Grid.

A View displaying data in Data Grid format

• Click theicon given for a Dimension to open the Category Properties.
• Adjust the Width field.

• Select the APPLY option.

• Click theicon given for a Measure to open the Series Properties.
• Adjust the Width field.

• Select the APPLY option.

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 given illustration to understand the field re-ordering functionality provided for the Grid chart.

Re-ordering Feilds in the Grid Component

Please Note:

• Users can only do reordering from dimension to dimension, and measure to measure. Cross-category re-ordering is not supported.

• User can adjust the size of the Date columns as well.