PivotGrid

Description:

Pivot Grid

PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data.

Allowed Parent Components:

1. Card Body

2. Horizontal Section

3. Vertical Section

Allowed Child Components:

1. Calculated Column

2. Date Column

3. Hidden Column

4. Number Column

5. Popover

6. Pulse

7. String Column

8. Trigger After Query

9. Trigger Before Render

10. 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