Multiple Aggregation in Pivot JS


Anand Ramdhumal

2024-09-23 16:37:09


1. Kindly configure report inside Admin module -> report development form.

2. Need to select Display Type as Multiple Aggregation

 

3.  Need to add Multiple Aggregation Parameters as shown below

Sample Example of parameters:

{ "agg1": { "aggType": "Count", "arguments": ["Member Code"], "name": "Count of Member code", "varName" :"a", "renderEnhancement" : "barchart" }, "agg2": { "aggType": "Average", "arguments": ["Unit Code"], "name": "Avg(Unit Codes)", "varName" :"b", "hidden" : false, "renderEnhancement" : "none" }, "agg3": { "aggType": "Sum", "arguments": ["Name"], "name": "Sum(Member Names)", "varName" :"c", "hidden" : false, "renderEnhancement" : "heatmap" } }

 

3. Pivot report will get displayed as below,