Files to look at:
Dashboard for WinForms - How to calculate and display totals for the hidden measure
This example demonstrates how to calculate a total value (distinct count) for a hidden measure and display it in the dashboard item's caption.
The DashboardViewer.CalculateHiddenTotals property is set to true to calculate totals for a hidden OrderID measure.
The DashboardViewer.GetItemData method retrieves the MultiDimensionalData object that contains the item's data. The MultiDimensionalData.GetValue method returns the totals value for the specified measure. The DashboardViewer.CustomizeDashboardItemCaption event is handled to display the value in the PieDashboardItem's caption.
API in this example:
- DashboardViewer.CustomizeDashboardItemCaption event
- MultiDimensionalData class
- MultiDimensionalData.GetMeasures method
- MultiDimensionalData.GetValue method
- DashboardViewer.CalculateHiddenTotals property
- DashboardViewer.ConfigureDataConnection
- ExtractDataSourceConnectionParameters class