Resource Names Repeated or Duplicated in Clarity MUX Reports

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When building a custom report within the new Clarity MUX Report Designer, adding a Table widget causes individual resource names to be duplicated or repeated multiple times across the rows.

Environment

Clarity 16.4.2

Cause

When a custom data provider returns multiple detailed transactional rows for a single resource (such as daily timesheet actual entries or activity slices), a standard Table widget mapping the resource name column will naturally display a row for every returned record. Without grouping criteria, a unique constraint, or aggregation inside the query logic itself, the resource name repeats for every data point fetched.

Resolution

To resolve the duplicate resource rows, modify the custom SQL query or data provider logic to correctly aggregate or filter data rows before passing them to the MUX Report interface.