The topics in this section describe the features available in the Grid dashboard item, and provide information on how to create and customize grids
The Web Dashboard allows you to bind various dashboard items to data in a virtually uniform manner. To learn more, see the Bind Dashboard Items to Data topic.
The only difference is in the data sections that the required dashboard item has. This topic describes how to bind a Grid dashboard item to data.
The image below shows a sample Grid dashboard item that is bound to data.
To bind the Grid dashboard item to data, click a placeholder contained in one of the available data sections and select the required data source field in the Binding section of the invoked data item menu.
The table below lists and describes the Grid’s data sections.
|Columns||Dimension or Measure (depending on the selected column type)||Contains data items that provide values for grid columns. The data item menu allows you to select the column type and specify their options.|
|Sparkline||Dimension||Contains a data item that provides arguments for sparkline columns. To learn more, see Columns.|
The Grid dashboard item supports four types of columns.
A dimension column displays values from the bound data item “as is”. If the dimension column is bound to a data source containing images, it can display images.
A dimension column allows you to display hyperlinks in the Grid dashboard item. You can provide hyperlinks as a separate data column, or they can be automatically created at run-time from any column using the specified URI pattern.
A measure column displays summaries calculated against data in the bound data item.
Values in the measure column can be displayed as text or represented by bars.
To select between these modes, open the column menu and go to the Options section.
A delta column calculates summaries against two measures: the Actual value and the Target value. When you switch the column type to Delta, a new Target data item container appears.
The difference between these values is displayed within the column.
You can configure delta options in the Delta Options section of the column menu.
A sparkline column visualizes the variation of summary values over time.
The sparkline column is bound to the measure providing sparkline values and to the dimension providing a date-time interval. Add the required date-time dimension to the Sparkline placeholder to show values depending on time.
You can configure sparkline options in the data item’s Sparkline Options section.
When you drop a data item into the Columns section, the type for the new column is determined automatically based on the data type.
To change the column type, open the column menu and click the corresponding type button.
To enable interaction between the Grid and other dashboard items, you can use the interactivity features, as Master Filtering and Drill-Down.
You can use the Grid dashboard item as a filter for other dashboard items. To learn more about filtering concepts common to all dashboard items, see the Master Filtering topic.
The Grid dashboard item supports filtering by rows.
When Master Filtering is enabled, you can click a grid row (or multiple rows) to make other dashboard items only display data related to the selected record(s).
To enable Master Filtering, go to the Grid’s Interactivity menu and select the required Master Filtering mode.
To reset filtering, use the Clear Master Filter button (the icon) in the Grid’s caption.
The built-in drill-down capability allows you to change the detail level of data displayed in dashboard items on the fly. To learn more about drill-down concepts common to all dashboard items, see the Drill-Down topic.
The Grid dashboard item supports drill-down for rows.When drill-down is enabled, you can click a grid row to view the details.
Drill-down requires that the Columns section contains several dimensions at the top, from the least detailed to the most detailed dimension.
To enable Drill-Down, go to the Grid’s Interactivity menu and turn the Drill-Down option on.
To return to the previous detail level, click the Drill Up button (the icon) in the Grid’s caption.
Use conditional formatting to highlight individual cells or rows based on specific conditions. You can apply format rules to the dimension and measure column types. You can use hidden measures to specify a condition used to apply formatting to visible values.
Format rules that can be applied to different data item types are as follows:
- Icon Ranges
- Color Ranges
- Gradient Ranges
- Bar Color Ranges
- Bar Gradient Ranges
- Value (with the condition type set to Equal To, Not Equal To or Text that Contains)
- A Date Occurring (for dimensions with a continuous date-time group interval)
- Icon and Color Ranges
- Color Ranges
- Gradient Ranges
- Bar Color Ranges
- Bar Gradient Ranges
Refer to the following topic for more information about format condition types: Conditional Formatting in Web Dashboard.
You can create and edit format rules in the Conditional Formatting section that is located in the following places:
Refer to the following topic for information on how to create and edit format rules: Conditional Formatting in Web Dashboard.
The format rule’s Miscellaneous section contains the following properties that are specific to the Grid item:
|Enabled||Enables/disables the current format rule.|
|Applied to Row||Applies the current format rule to a row.|
The Grid dashboard item enables you to add a summary value (a total) calculated against displayed values of an individual column, and to show the result under this column. Note that you can add any number of totals for each column. For example, you can obtain the number of column records, average or maximum value, etc.
You can use the following summary functions when creating totals.
- Count - The number of records.
Sum - The sum of the values.
- Min - The smallest value.
- Max - The largest value.
Average - The average of the values.
- Auto - The total is calculated using the type of summary function specified for the measure corresponding to the current Grid column. Note that in this case, the total is calculated based on values of the corresponding data field from the underlying data source.
You can create totals using different sets of summary functions. This depends on the type of the data source field providing data for the target column.
Note that the Auto type is available only for the measure column.
To create a total, open a data item menu and go to the Totals section. Click “+” to add a new total.
To change the total type, open the drop down list and select the required type.
You can delete the required total by clicking the Delete button (the icon).
The Grid dashboard item allows you to customize its layout in various ways. You can manage the width of grid columns, specify the visibility of column headers, enable cell merging, etc.
To access the layout settings, use the Layout section in the Grid’s Options menu.
The following settings are available.
- Horizontal Lines - Specifies grid’s horizontal line visibility.
- Vertical Lines - Specifies grid’s vertical line visibility.
- Banded Rows - Specifies the different background for odd and even rows.
- Column Headers - Allows you to toggle column header visibility.
- Word Wrap - Displays cell content on multiple lines if the size of a dashboard item is insufficient to completely display the cell content on a single line.
- Column Width Mode - Specifies column widths of the entire Grid using one of the available modes.