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.
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.
Filter: Select a filter condition from the drop-down menu.
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.
The user can modify the following information for a dragged Dimension.
Display Name
Column Width
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
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.
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.
Click the icon given for a Dimension to open the Category Properties for dragged Dimensions.
Click the icon given for a Measure to open the Series Properties for a dragged Measures.
