Chart - DMR Summary Numbers

Modified on Wed, 21 Jan at 5:38 PM

TABLE OF CONTENTS

Description
Summary Numbers Display
Widget Variants
Advanced Arguments
Examples
Notes
Use Cases

Description

The DMR Summary Numbers chart enables you to display up to three summary numbers on a Dashboard by counting or summing columns from a Datamining Report (DMR). The chart uses the columns and filters defined in the DMR, rather than the Dashboard DataSource, allowing you to preserve any complex filtering within the DMR while maintaining dashboard-wide control via the main DataSource panel.

Any column from the DMR can be used in the chart, including Expression Columns.

CountWidget Example

Summary Numbers Display

The chart displays up to three different numbers, each with a corresponding label.
- The first number is displayed in the centre.
- The second number appears at the top.
- The third number appears at the bottom.
Use sorting to control display order. Only the first three rows from the result set will be shown.
For best results, configure your DMR to ensure that relevant data appears in the top three rows.

With Labels
Without Labels

Advanced Widget Arguments

Parameter	Description	Required
Datamining Report Id	ID of the Datamining Report to use	Yes
Group By Column	Internal column name to use for grouping/pivoting	Yes
Count or Sum	Specify aggregation type and column (e.g., `Sum: UserMigrations_Total` or `Count: Applications_AppId`)	No
Top	Limit results to top N rows (e.g. `Top: 20`)	No
Sort	Sorting order (`asc` or `desc`) (e.g. `Sort: desc`)	No
Filter	Additional filter to apply (e.g. `Filter: Devices_HostName like 'PC0006*'`)	No
DataSource: DMR	Force use of the DMR DataSource (e.g. `DataSource: DMR;`)	No

Multiple parameters should be separated by a semicolon (;).
Carriage returns are permitted between parameters.
Multiple filters are allowed. All referenced columns must exist in the DMR.

Examples

Example 1: Sum

Sum: UserMigrations_Total; Top: 15; Sort: Desc;

Example 2: Count with Filter

Count: UserMigrations_HostName; Filter: Devices_HostName like 'PC0006*'

Notes

The DataSource used by default is the one set in the DMR. Switching to the Dashboard DataSource is not supported for this chart.
Filters set within the DMR will be applied regardless of any chart-specific DataSource settings.
Expression columns can be used as grouping or aggregation targets, provided they exist in the DMR.

Use Cases

Displaying the total number of migrated users by application vendor.
Summing migration progress for a defined set of hosts filtered by hostname pattern.
Highlighting the top three application vendors based on installed user count.

Further Support

For additional assistance, visit the ManagementStudio Service Desk to search the knowledge base or create a support ticket.