Global Dashboard

Global dashboard shows data related to multiple ItemTypes in the form of table, worksheet, and report controls. You can have a table or worksheet show list of items from a specific ItemType with pre-applied filter. You can also have reports generated based on different ItemTypes.

Table control can render items of an ItemType based on the pre-applied filter. You can modify the filter if admin configures the table with “Enforce Filter” as false. It has features like:

• Computed Columns
• Validation Rules
• Conditional Formatting
• Variable row height; row height will be adjusted based on the cell content
• Cell navigation using navigation keys and all other shortcut keys are allowed for operations like Copy, Paste, Delete etc.
• Row reordering is supported with Drag & Drop operations

Table column widths can be configured in percentage or pixels by admin. With percentage option, horizontal scrollbar will never be shown. If admin configures the table with “Cascade Delete” setting, all child relationships and related items are deleted when the context item is deleted. Admin can also configure specific column as “Freeze Column” to fix columns that are always visible and don’t move along with horizontal scrollbar. Table can be configured to show either Scrolling or Pagination by admin.

Worksheet control provides Excel experience for creating data sheets within Innovator based on ItemType data. Worksheet columns are defined based on ItemType properties and are constrained with property data types. It can show nested rows for a specific item with child relationships data. It has features like:

• Computed Columns,
• Validation Rules,
• Conditional Formatting,
• Cell navigation using navigation keys and all other shortcut keys are allowed for operations like Copy, Paste, Delete etc.
• Excel type of sorting and filtering. You can copy-paste between Excel and Worksheet control along with Drag & Drop operations for Row reordering,
• Excel features like Drag & Drop, Cell Copy by Drag and Undo & Redo etc.

Worksheet column widths can be configured in percentage or pixels by admin. With percentage option, horizontal scrollbar will never be shown. If admin configures the worksheet with “Cascade Delete” setting, all child relationships and related items are deleted when the context item is deleted. Admin can also configure specific column as “Freeze Column” to fix columns that are always visible and don’t move along with horizontal scrollbar.

Report control can be configured in Dashboard by the administrator using QueryDefinition. For Dashboards, report control should be configured with any QueryDefinition, which doesn’t expect any item context. At runtime, report control executes QueryDefinition to get DataSource for the report. It can support any type of report like Pivot Table, Tree Table, Table Barchart, Heatmap, Row Heatmap, Column Heatmap, Line Chart, Bar Chart, Stacked Bar Chart, Area Chart, Stacked Area Chart, Pie Chart and PowerBI. All report types can show drilldown reports.