Add Dashboard Items and Perform Basic Data Shaping

After creating a dashboard and providing data to it, add dashboard items to display visual and textual information in a dashboard.

Refer to the Designing Dashboard Items document for a complete list of available dashboard items.

Add a Grid

Click the Grid button in the Toolbox or drag and drop this item onto the dashboard surface.

rs-drag-grid-dashboard-item

This creates a new configurable Grid dashboard item.

rs-empty-grid-dashboard-item

Select the item and open its Bindings menu to see the data source to which this item is bound and empty placeholders for providing data.

Click Add Column and choose the CategoryName data field in the invoked list.

rs-grid-dashboard-item-add-column

Add one more column and select the ExtendedPrice field.

rs-grid-dashboard-item-columns

In this example, the first column is a dimension and the second column as a measure. Both these values can be of any type - string, date-time or numeric.

  • The dimension is used to provide discrete categorical information. The dashboard does not summarize the dimension values, but groups identical values. You can perform grouping, sorting, or display the top values for the dimension values.
  • The measure is used to summarize data against grouped dimension values. The dashboard calculates an appropriate summary function against measure values. You can also customize the data format settings that affect how summary values are displayed.

The dashboard calculates Sum for numeric measures by default. You can select the required summary function in the Summary Type drop-down list.

rs-grid-dashboard-item-summary-type

Expand the Format section and apply required currency formatting to this column.

rs-grid-dashboard-item-column-format

Select the CategoryName column, expand the Options section and specify the desired caption.

rs-grid-dashboard-item-column-caption

Open the Data Shaping section and select the ExtendedPrice column in the Sort By drop-down list to sort grid data against summary values calculated for the selected measure. You can choose the ascending or descending sort order.

rs-grid-dashboard-item-sorting

Add a Chart

Click the Chart button in the Toolbox to add a new chart item to the dashboard.

rs-add-chart-dashboard-item

Open the chart's Bindings menu, click the Add Values placeholder and select the ExtendedPrice field.

rs-chart-dashboard-item-add-values

Click Add Argument and select the OrderDate data field. The Group Interval property is set to Year by default. The chart now displays extended price values for each year.

rs-chart-dashboard-item-add-arguments

Add one more OrderDate argument and set its Group Interval option to Quarter to display data hierarchically.

rs-chart-dashboard-item-group-interval

Add a Pie

Click the Pies button in the Toolbox to add a Pie item that shows each value's contribution to a total.

rs-add-pies-dashboard-item

In the Bindings menu, specify the ExtendedPrice data field for values and the SalesPerson field for arguments of this pie.

rs-add-pies-dashboard-item-values-and-arguments

Add Cards

Add the Card dashboard item by clicking the corresponding button in the Toolbox.

rs-add-cards-dashboard-item

Invoke the Bindings menu, click Add Card and select the ExtendedPrice data field for calculating values displayed within cards. Click Add Series and select the Country field used to label cards. Then, click Add Sparkline and choose the OrderDate field to visualize the variation of card values over time.

rs-cards-dashboard-item-settings

View the Result

The following image demonstrates the resulting dashboard:

rs-dashboard-items-result

See Also