Refer to the Designing Dashboard Items document for a complete list of available dashboard items.
Click the Grid button in the Toolbox or drag and drop this item onto the dashboard surface.
This creates a new configurable 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.
Add one more column and select the ExtendedPrice field.
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 dashboard calculates Sum for numeric measures by default. You can select the required summary function in the Summary Type drop-down list.
Expand the Format section and apply required currency formatting to this column.
Select the CategoryName column, expand the Options section and specify the desired 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.
Click the Chart button in the Toolbox to add a new chart item to the dashboard.
Open the chart's Bindings menu, click the Add Values placeholder and select the ExtendedPrice field.
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.
Add one more OrderDate argument and set its Group Interval option to Quarter to display data hierarchically.
Click the Pies button in the Toolbox to add a Pie item that shows each value's contribution to a total.
In the Bindings menu, specify the ExtendedPrice data field for values and the SalesPerson field for arguments of this pie.
Add the Card dashboard item by clicking the corresponding button in the Toolbox.
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.
The following image demonstrates the resulting dashboard: