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.
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.
The user can modify the following information for a dragged Dimension.
Display Name
Column Width
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
The user can also set Ranges and their colors manually. The manually set range will get 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 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 given illustration to understand the field re-ordering functionality provided for the Grid chart.
Please Note:
Users can only do reordering from dimension to dimension, and measure to measure. Cross-category re-ordering is not supported.
Users can adjust the size of the Date columns as well.
Last updated
