Optimize: In reports raw data table is not filled when grouped by ProcessInstance is used

[venetrius]

Environment (Required on creation)

Reproduced on: 3.14.1 & 3.15

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket)

When creating a report with multiple data source and grouping clause include Process Instance the rawdata table is not populated.

Steps to reproduce (Required on creation)

1. Create a new non-table report with 2 data source, using a Process Instance view and a group by clause. Running the report produces a graph and the raw data table is visible:

screenshot

2. Add Process Instance to the group by clause and run the report. Running the report produces a graph but no data is show in the raw data table, even though pagination elements are present (and data is received from the server).

screenshot

Observed Behavior (Required on creation)

Running the report produces a graph but no data is show in the raw data table, even though pagination elements are present (and data is received from the server).

screenshot

Expected behaviour (Required on creation)

Either the table is filled with data properly
OR the logic is changed so the raw data table is not present. This is hinted in this ticket:
"The raw data panel should not be visible in combined reports" (But this refers to combined report and not report with multiple sources)

Root Cause (Required on prioritisation)

In https://github.com/camunda/camunda-optimize/blob/3ae64708bedb37693397aaa5d3e84871b2e5f4ad/optimize/client/src/modules/services/reportService.js#L17 if:

  if (report?.data?.groupBy?.type === 'none' && report?.data?.distributedBy?.type === 'process') {
    report = convertHyperMapToMap(report);
  }

Then https://github.com/camunda/camunda-optimize/blob/3ae64708bedb37693397aaa5d3e84871b2e5f4ad/optimize/client/src/modules/services/reportService.js#L76:

function convertHyperMapToMap(report) {
  const newResult = {...report.result};

  newResult.type = 'map';
  if (newResult.measures) {
    newResult.measures = newResult.measures.map((measure) => ({
      ...measure,
      type: 'map',
      data: measure.data[0]?.value || [],
    }));
  }

  return {...report, result: newResult};
}

this will set measures.data to be null. The table is provided with no data so it renders no data.
I assume this logic is required, but I have not find the use case yet.

Solution Ideas

A, Show data correctly

We can update the check to not convert result to hyperMap if the type is rawd, that way the data is preserved

  if (
    report.result.type !== 'raw' &&
    report?.data?.groupBy?.type === 'none' &&
    report?.data?.distributedBy?.type === 'process'
  ) {
    report = convertHyperMapToMap(report);
  }

B, Hid raw table

Can be done by adjusting: https://github.com/camunda/camunda-optimize/blob/893f21f21ad58ed1c6527bbc7310162979ceb793/optimize/client/src/components/Reports/ReportView.js#L179

Hints

Links

https://jira.camunda.com/browse/SUPPORT-25573

Breakdown

Pull Requests

Preview Give feedback

No tasks being tracked yet.

Dev2QA handover

• Does this ticket need a QA test and the testing goals are not clear from the description? Add a Dev2QA handover comment

[yanavasileva]

Removing from the Project until it's scheduled.