ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: TeeJT on December 02, 2016, 01:04:31 pm

Title: Display grouping data such as Max, Min, Avg, Total for every group
Post by: TeeJT on December 02, 2016, 01:04:31 pm

Is it possible to display grouping data such as Max, Min, Avg, Total for every group
In this demo it is shown for the whole dataset but I need to be shown for each and every group.
http://paramquery.com/pro/demos/summary_json

Title: Re: Display grouping data such as Max, Min, Avg, Total for every group
Post by: paramvir on December 02, 2016, 09:42:04 pm

Please use groupModel.showSummary option.

http://paramquery.com/pro/api#option-GM-showSummary

Title: Re: Display grouping data such as Max, Min, Avg, Total for every group
Post by: TeeJT on December 05, 2016, 07:22:50 am

What I need is that for one column - I need to show more than one summary e.g. Minimum, Maximum and Average - can it be done?

Title: Re: Display grouping data such as Max, Min, Avg, Total for every group
Post by: paramvir on December 05, 2016, 10:59:17 am

Yes! Multiple summaries can be shown with help of custom aggregates by extension of pq.aggregate object:

http://paramquery.com/pro/api#method-aggregate

Example: http://paramquery.com/pro/demos/group_rows_custom_summary

Title: Re: Display grouping data such as Max, Min, Avg, Total for every group
Post by: TeeJT on December 05, 2016, 11:24:45 am

Thank you for your prompt reply. Is it possible to add <BR> after each aggregate item so that the column width will have to be lengthened so much?
Sorry I have done it. Thanks.
Is there a way to delete a post?