Grid allows you to present data in tabular form. To bind the Grid dashboard item to data, drag and drop a data source field to a placeholder contained in one of the available data sections.
The Grid dashboard item supports four types of columns.
- Dimension Column. Displays grouped values from the bound data item and allows you to provide discrete categorical information.
- Measure Column. Displays summaries calculated against data in the bound data item.
- Delta Column. Bound to two measures, calculates summaries for both measures, and displays the difference between these summaries.
- Sparkline Column. Displays values in the bound data item using sparklines.
When you drop a data item into the Columns section, the type for the new column is determined automatically based on the data type. The type of the column is indicated within the corresponding data item container in the DATA ITEMS area.
Column type indicators are defined as follows.
To change the column type, click the column type indicator. In the invoked Column Options window, select the column type from the Column type section.
The 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 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, invoke the Column Options window and select Value or Bar.
If bars are displayed, use the Always show zero level check box to specify whether the bar's zero level is always visible.
The built-in drill-down capability allows end-users to change the detail level of data displayed in dashboard items on the fly. 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, click the Drill Down button in the Data Ribbon tab.
To return to the previous detail level (drill up), use the corresponding button within the Grid caption, or the Drill Up command in the context menu.
The Grid dashboard item supports the conditional formatting feature that provides the capability to apply formatting to grid cells whose values meet the specified condition. This feature allows you to highlight specific cells or entire rows using a predefined set of rules. To create a new format rule for the Grid's dimension/measure, do one of the following.
- Click the Options button next to the required measure/dimension, select Add Format Rule and choose the condition.
- Right-click the column header corresponding to the required measure/dimension and select Add Format Rule.
- Use the Edit Rules dialog. Depending on the selected format condition, the dialog used to create a format rule for Grid contains different settings. For instance, the image below displays the Greater Than dialog corresponding to the Value format condition.
The Grid dashboard item enables you to add a summary value (a total) calculated against displayed values of an individual column, and 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 create totals using different sets of summary functions. This depends on the type of the data source field providing data for the target column. To create a total, use the context menu of the column header. Right-click the required column header, select Add Total and specify the type of summary function used to calculate a total.
To change the total type, right-click the required total and select a new total type.
To configure table layout, switch to Design tab on the ribbon and try to play with provided functions. For example, you may turn word wrapping feature to wrap words in table cells. Or use Banded rows button to colorize odd and even rows.