Stats Report

Displays a report based on a Stats Query, presenting grouped and formatted statistics for batch processing activity.

Remarks

The Stats Report control generates and displays a detailed report from a configurable Stats Query. It provides a flexible, interactive interface for analyzing batch processing statistics, supporting grouping, sorting, formatting, and totals calculation. The report is designed to help users understand operational performance, identify trends, and compare results across processes, users, machines, or time periods.

Overview

Stats Report is typically presented as a main panel or tab within the reporting or analytics section of the Grooper UI. It executes a Stats Query to retrieve and aggregate data from the SessionStats and CustomStats tables, then displays the results in a structured, tabular or card-based layout. The report adapts to the query's grouping, filtering, and formatting options, making it suitable for a wide range of operational and business reporting needs.

Key Features

• Configurable Query Source:

  • Driven by a Stats Query, which defines filters, grouping, sorting, and formatting for the report.
  • Supports grouping by process, step, activity, user, machine, or time period (day, week, month, etc.).
  • Filters can be applied for time frame, process, step, activity, user, or machine.

• Grouped and Formatted Output:

  • Results are grouped by the selected category (e.g., process, user, time period).
  • Each group displays a set of statistics, such as tasks processed, processing time, run time, and custom metrics.
  • Statistics are formatted using the query's number and time format settings (supports .NET format strings).
  • Optionally displays totals or summary rows for each group.

• Sorting and Ordering:

  • Statistics within each group can be sorted by name or value, in ascending or descending order.
  • The order is controlled by the query's 'Order By' and 'Sort Direction' properties.

• Totals and Footer Statistics:

  • When enabled, the report calculates and displays totals such as "Tasks Processed", "Processing Time", and "Run Time".
  • Totals are computed across all sessions in each group and presented as summary rows.

• Dynamic Layout:

  • Supports both table and card layouts, adapting to the data and user preferences.
  • The layout is controlled by the 'UseTableLayout' property.

• Integration:

  • Designed to work with saved Stats Queries for consistent, repeatable reporting.
  • Can be exported or printed for sharing and documentation.

Interactive Components

• Category Selector:

  • Displays the available groupings (e.g., process, user, time period) as tabs or dropdowns.
  • Users can switch between categories to view different breakdowns.

• Statistics Table or Cards:

  • Shows statistics for each group, with formatted values and optional totals.
  • Supports sorting, column resizing, and expandable/collapsible groups (in some layouts).

• Formatting Controls:

  • Applies number and time formatting as specified in the Stats Query.
  • May include options for changing format or exporting data.

Usage Guidance

• Use Stats Report to analyze batch processing performance, compare activity across users or machines, or track trends over time.
• Adjust the Stats Query to filter, group, or format the report as needed for your business scenario.
• Review totals and summary rows to quickly assess overall performance or identify outliers.
• Export or print the report for documentation, compliance, or sharing with stakeholders.

Accessibility

• Fully navigable by keyboard and mouse.
• Screen reader support for all report content, including groupings and statistics.
• Visual highlighting for selected categories, focused rows, and summary totals.

Example

┌────────────── Stats Report ──────────────┐
│ Group By: User                           │
│ ┌───────────────┬─────────────────┬─────┐│
│ │ User          │ Tasks Processed │ Run ││
│ ├───────────────┼─────────────────┼─────┤│
│ │ Alice         │ 120             │ 8h  ││
│ │ Bob           │ 95              │ 6h  ││
│ │ Carol         │ 110             │ 7h  ││
│ ├───────────────┴─────────────────┴─────┤│
│ │ Totals:       │ 325             │ 21h ││
│ └───────────────────────────────────────┘│
└──────────────────────────────────────────┘

Used By

Stats ViewerStats Result Set