ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: wd_perf on March 28, 2022, 09:11:09 pm

Title: Pivot Help. How to create multiple aggregates from the same column
Post by: wd_perf on March 28, 2022, 09:11:09 pm

Can you please provide an example on how can I change the following pivot demo to be able to allow the use to display multiple aggregates for the same column? For example I want to be able to use the Pivot Mode to display max, min, avg at the same time for any column like Gold.

https://paramquery.com/pro/demos/pivot

Title: Re: Pivot Help. How to create multiple aggregates from the same column
Post by: paramvir on March 29, 2022, 11:35:08 am

Please follow these steps:

Define the columns in colModel.

Code: [Select]

            {title: "Gold", dataIndx: "gold", width: 100, dataType:'integer',
                tpCls: 'gold',denyGroup: true, denyPivot: true
            },
            {title: "Gold", dataIndx: "gold1", width: 100, dataType:'integer',
                tpCls: 'gold',denyGroup: true, denyPivot: true, editable: false
            },
            {title: "Gold", dataIndx: "gold2", width: 100, dataType:'integer',
                tpCls: 'gold',denyGroup: true, denyPivot: true, editable: false
            },           

Link new columns with the original column with help of formulas:

Code: [Select]

            formulas: [
                ['gold1', function(rd) {
                  return rd.gold;
                }],
                ['gold2', function(rd) {
                  return rd.gold;
                }]
            ],


Title: Re: Pivot Help. How to create multiple aggregates from the same column
Post by: wd_perf on March 29, 2022, 05:47:29 pm

I see. Thanks for that example. Is it possible to do this without explicitly creating a new columns in the drag and drop selector? The use case I'm targeting would contain a few dozen columns. While this approach would work, it would explode the number of columns seen by the user.

Title: Re: Pivot Help. How to create multiple aggregates from the same column
Post by: paramvir on March 30, 2022, 01:53:38 pm

columns can be hidden from toolPanel with tpHide property.