[ui5-analytical-table]: When grouping by column A, the grouped row has an incorrect aggregated value in the grouped column #8060
Description
Bug Description
I have a ui5-analytical-table where it is possible to group by columns, even creating a combination of grouped columns. In such a table, in one of our scenarios, the value of column C, depends on the value of column B.
Both columns B and C have overwritten the event "aggregate".
Given I grouped the analytical table by columns A
When I group the table by column B
Then, the grouped row (where the value of the grouped columns is not shown) aggregates column B by selecting the first value, not triggering the aggregation events.
Example:
In the table in the image, I have the following aggregations:
- Min Status column: returns a single status, returns "In Progress" if at least one row in the grouped rows contains this status. Returns "Finished" if all grouped rows are finished.
- Job Due Date: returns the min date of the grouped rows. If Min Status column = Finished, then show "Finished"
As you can see in the expanded grouping, Job Due Date = "Finished", despite having "In Progress" rows in its group. It happens because in the grouped row, props.cell.values = 'Finished'. This value is not the result of the aggregation events described above, but simply the selection of the first Min Status value.
Affected Component
ui5-analytical-table
Expected Behaviour
The grouped row should respect what is defined in the aggregation, even not showing the value in the cell.
Isolated Example
No response
Steps to Reproduce
...
Log Output, Stack Trace or Screenshots
No response
Priority
Medium
UI5 Web Components Version
2.17.1
Browser
Chrome
Operating System
No response
Additional Context
No response
Organization
No response
Declaration
- I’m not disclosing any internal or sensitive information.