Knowledge has a beginning but no end

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,

Related Articles
  • Reports FAQ
  • Setup auto mail from any report
  • Filename of a particular report to change while downloading or receiving mails
  • DOCX XLSX Print Configuration FAQs
  • Custom Report
  • Custom Report Creation Using Reporting Tool
  • Dashboard Creation Using Reporting Tool
  • Indian Currency Format in DOCX Report
  • Add Jar File for HelperFunctions in iReport for Jasper Reports
  • SQL Report Not Working On Custom State
  • Charts in Pivot Reports
  • Jasper Support Links
  • Developer Links
  • Pivot Report
  • Reporting Tool
  • Docx Report
  • Report Parameters
  • To Open Form Using Form Entry Record ID in Summary Report
  • Pramukh Group builds a scalable and adaptable real estate business system
  • How to convert HTML Tag to Plain text In Jasper Report
  • Wbs Revision Report
  • Hide Show Report On Relation Form Or Field Value Condition
  • Page Exceeds to 2000limit in Jasper report
  • Pivot View of List To Explore the Data Science
  • MRT Report Tool
  • Jasper iReport Property To Format Numbers properly in Excel Print
  • Excel Report Development in StrategicERP
  • RTGS Report For Multi Ledger Payment
  • Dynamic DOCX report using xdocreport and template to add an image
  • How to insert conditional expression in docx file template
  • Strip Chart and Chainage Wise DPR
  • Multiple Aggregation in Pivot JS