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 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.
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.
The user can modify the following information for a dragged Dimension.
Display Name
Column Width
Series (Measure) Properties of Grid
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.
Check out the illustration to understand the field re-ordering functionality for the Grid chart.
Last updated
