PivotGrid
Description:
Pivot Grid
PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data.
Allowed Parent Components:
Card Body
Horizontal Section
Vertical Section
Allowed Child Components:
Calculated Column
Date Column
Hidden Column
Number Column
Popover
Pulse
String Column
Trigger After Query
Trigger Before Render
Trigger On Aggregate Click
Properties
➤ Allow Column Resizing
Check this to allow users to resize grid columns.
Allowed Values: Yes/No
➤ Allow Column Sorting
Check this to allow users to sort column values. This will enable click on header cell which will sort the values in ascending or descending order.
Allowed Values: Yes/No
➤ Borders
Check this to show borders to the Grid.
Allowed Values: Yes/No
➤ Hide Column Lines
Check this to show lines between the grid columns.
Allowed Values: Yes/No
➤ Strip Rows
Check this to add zebra-striping to the rows within the table
Allowed Values: Yes/No
➤ Show Single Level Child At Same Level
Enable this to show the parent and it's child(only if it is single) at the same level.
Allowed Values: Yes/No
➤ No Drilldown
Enable this to hide drill down in the columns.
Allowed Values: Yes/No
➤ Hide Configurator
Enable this to hide pivot configurator from the grid header
Allowed Values: Yes/No
➤ Max Freeze Rows Column Width
Enter a numeric value to control the maximum width of the frozen rows column.
Allowed Values: Any number value
➤ Group By Attribute
Group by clause will be performed on the selected attribute.
Allowed Values: Group by clause will be performed on the selected attribute.
➤ Show Group Before
Enable this to show the group summary first.
Allowed Values: Yes/No
➤ Empty Value Text
Add a value to display if pivot value is empty
Allowed Values: Free text field
➤ Aggregate Column Colors
specify custom colors to be applied on aggregate column values
Allowed Values: Free text field
➤ Row Column Colors
specify custom colors to be applied on row column values
Allowed Values: Free text field
➤ Summary Column Colors
specify custom colors to be applied on row summary column values
Allowed Values: Free text field
➤ Hide Row Summary
Enable this to hide row level summary values.
Allowed Values: Yes/No
➤ Hide Footer
Enable this to hide the footer i.e. Grand Total.
Allowed Values: Yes/No
➤ Height
Allowed Values: Any number value
➤ Row Height
Enter a numeric value to change the height of each row in the pivot grid. By default, height is 36
Allowed Values: Any number value
➤ Use Existing Data Source
Choose this prop if you want to reuse a Data Source that was defined on some other component on this page or any of the parent abstract pages.
Allowed Values: Yes/No
➤ Data Source
Select a datasource from the list.
Allowed Values: Select a datasource from the list.
➤ Data Source Alias
Allowed Values: Free text field
➤ Default Where Clause
Allowed Values: Free text field
➤ Max Rows
Allowed Values: Any number value
➤ Order By Clause
e.g. #firstAttr#, #secondAttr# DESC
Allowed Values: Free text field
➤ Auto Query
Check this property to query the selected datasource on component render.
Allowed Values: Yes/No
➤ Execute Count SQL
Check this to execute count SQL to get the total number of rows in the database on a query. You can get this value by using the expression: #{DataStore.totalLength}
Allowed Values: Yes/No
➤ Execute Distinct SQL
Check this to execute distinct SQL to get the total number of distinct rows in the database on a query.
Allowed Values: Yes/No
➤ On Aggregate Click
Allowed Values: Controller Function
➤ Margin
Select a value to add margin on all four sides of the component. It is a shorthand for margin-top, margin-right, margin-bottom, and margin-left.
Allowed Values: Any number value
➤ Margin Bottom
Select a value to add margin on the bottom of the component.
Allowed Values: Any number value
➤ Margin Left
Select a value to add margin on the left of the component.
Allowed Values: Any number value
➤ Margin Right
Select a value to add margin on the right of the component.
Allowed Values: Any number value
➤ Margin Top
Select a value to add margin on the top of the component.
Allowed Values: Any number value
➤ Padding
Select a value to add padding on all four sides of the component. It is a shorthand for padding-top, padding-right, padding-bottom, and padding-left.
Allowed Values: Any number value
➤ Padding Bottom
Select a value to add padding in the bottom of the component.
Allowed Values: Any number value
➤ Padding Left
Select a value to add padding in the left of the component.
Allowed Values: Any number value
➤ Padding Right
Select a value to add padding in right of the component.
Allowed Values: Any number value
➤ Padding Top
Select a value to add padding in top of the component.
Allowed Values: Any number value
Last updated