Expanding rows is not working for dataset pivoted by multiple rows and 1 column over 1 calculated formula with custom data server api approach

Issue Description

This issue happens when pivoting a dataset by 2 or more rows and 1 column over 1 aggregated measure in the classic form view. On expanding the parent item to see all child items that make up the aggregated measure value, the parent item "disappears".

Version Details

• ngx-flexmonster: 2.9.124
• @angular/cli: ^18.2.12
• Node Version: 20.11.1

Attached Files Details

Refer to the attached zip file for reference materials on the issue.

• json fm multi row col aggregation expand bug.json
  • Pivot chart flexmonster json file
• json fm multi row col aggregation expand bug.gif
  • Example demo on the issue

Data Server API (Example used)

api1: https://localhost:8080/flexmonster/data-server/handshake

api1 req: { "type": "handshake", "version": "2.9.124" }

api1 Res: {"version":"2.9.124"}

 

api2: https://localhost:8080/flexmonster/data-server/fields

api2 req: { "index": "1712757", "type": "fields" }

api2 res: {"fields":[{"uniqueName":"filename","type":"string","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null},{"uniqueName":"id","type":"number","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null},{"uniqueName":"tablename","type":"string","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null},{"uniqueName":"operation","type":"string","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null},{"uniqueName":"command","type":"string","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null},{"uniqueName":"who","type":"string","caption":null,"hierarchy":null,"parent":null,"folder":null,"interval":null,"aggregations":[],"filters":null}],"aggregations":{"any":null,"date":["count","distinctcount"],"number":["sum","count","distinctcount","average","min","max"],"string":["count","distinctcount"]},"filters":true,"sorted":false}

 

api3: https://localhost:8080/flexmonster/data-server/members

api3 req: {"index":"1712757","type":"members","field":{"uniqueName":"operation"},"page":0}

api3 res: {"members":[{"id":"execution","value":"execution"},{"id":"file ops","value":"file ops"},{"id":"test console","value":"test console"}],"sorted":true,"pageTotal":1,"page":0,"nextPageToken":null}

 

api4: https://localhost:8080/flexmonster/data-server/members

api4 req: {"index":"1712757","type":"members","field":{"uniqueName":"command"},"page":0}

api4 res: {"members":[{"id":"test","value":"test"}],"sorted":true,"pageTotal":1,"page":0,"nextPageToken":null}

 

api5: https://localhost:8080/flexmonster/data-server/members

api5 req: {"index":"1712757","type":"members","field":{"uniqueName":"filename"},"page":0}

api5 res: {"members":[{"id":"run","value":"run"},{"id":"test","value":"test"},{"id":"test 1","value":"test 1"},{"id":"test 2","value":"test 2"}],"sorted":true,"pageTotal":1,"page":0,"nextPageToken":null}

 

api6: https://localhost:8080/flexmonster/data-server/select

api6 req: {"type":"select","index":"1712757","query":{"aggs":{"by":{"rows":[{"uniqueName":"operation"}],"cols":[{"uniqueName":"filename"}]},"values":[{"func":"sum","field":{"uniqueName":"id"}}]}},"querytype":"select","page":0}

api6 res: {"fields":null,"hits":null,"aggs":[{"keys":{"filename":"test 1","operation":"file ops"},"values":{"id":{"sum":121}}},{"keys":{"filename":"test","operation":"file ops"},"values":{"id":{"sum":245}}},{"keys":{"filename":"test 1","operation":"test console"},"values":{"id":{"sum":235}}},{"keys":{"filename":"run","operation":"execution"},"values":{"id":{"sum":375}}},{"keys":{"filename":"test 2","operation":"test console"},"values":{"id":{"sum":239}}}],"pageTotal":1,"page":0,"nextPageToken":null}