Performance Analytics: Replicating "Stack By" & Drilling Down to Records from D

[AbhishekT838281]

Hi Experts,

I am configuring a Performance Analytics dashboard reporting on Incident State Duration using a Database View (joining incident with metric_instance to track state changes and multiple re-entries).

Here is our current setup:

• Indicator Source Configuration:

  • Facts Table: Database View joining incident and metric_instance.

  • Conditions: Metric definition = Incident State Duration (tracking transition timestamps/durations), calculation complete = true.

  • Frequency: Daily.

• Automated Indicator 1: Sum of Duration across state transitions (Field: duration on metric_instance).

• Automated Indicator 2: Count Distinct Incidents (Field: id / number on incident).

• Formula Indicator: Average Duration per State ([[Sum Duration]] / [[Count Distinct Incidents]]).

• Breakdowns: Configured for State and Incident ID/Number, with Collect Breakdown Matrix enabled on the automated indicators.

We are trying to address two functional requirements and would appreciate your advice:

1. Replicating "Group By" and "Stack By" in a PA Widget

In standard ServiceNow reporting, we can configure a Bar/Column report with Group by: State and Stack by: Incident ID (or another attribute).

• In Performance Analytics, when using a Breakdown widget or Pivot, how can we display two breakdowns simultaneously (e.g., Level 1: State, Level 2: Incident ID) in a stacked column or bar visualization?

• Is a stacked visualization supported across two breakdown matrix levels in a single PA widget, or is a Pivot grid/Workspaces Data Visualization the recommended approach for this?

2. Drilling Down Directly to Records Instead of Analytics Hub

Currently, clicking into a widget score or breakdown takes users to the PA Analytics Hub / Detailed Scorecard.

• Stakeholders want a single click to open the underlying list of records (e.g., the filtered Database View rows or the underlying Incident records) rather than the KPI trend analysis.

• Is there a way to configure a PA widget to bypass Analytics Hub and go straight to the record list?

• If this is not natively supported (especially for Formula Indicators or joined views), what is the best practice architecture to present the filtered record list dynamically on the dashboard alongside the PA metric?

Looking forward to your insights and recommendations!