ParamQuery Grid
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Display grouping data such as Max, Min, Avg, Total for every group
« previous
next »
Print
Pages: [
1
]
Author
Topic: Display grouping data such as Max, Min, Avg, Total for every group (Read 2362 times)
TeeJT
Pro Ultimate
Jr. Member
Posts: 88
Display grouping data such as Max, Min, Avg, Total for every group
«
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
Logged
paramvir
Administrator
Hero Member
Posts: 6310
Re: Display grouping data such as Max, Min, Avg, Total for every group
«
Reply #1 on:
December 02, 2016, 09:42:04 pm »
Please use groupModel.showSummary option.
http://paramquery.com/pro/api#option-GM-showSummary
Logged
TeeJT
Pro Ultimate
Jr. Member
Posts: 88
Re: Display grouping data such as Max, Min, Avg, Total for every group
«
Reply #2 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?
Logged
paramvir
Administrator
Hero Member
Posts: 6310
Re: Display grouping data such as Max, Min, Avg, Total for every group
«
Reply #3 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
Logged
TeeJT
Pro Ultimate
Jr. Member
Posts: 88
Re: Display grouping data such as Max, Min, Avg, Total for every group
«
Reply #4 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?
«
Last Edit: December 05, 2016, 11:36:43 am by TeeJT
»
Logged
Print
Pages: [
1
]
« previous
next »
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
Display grouping data such as Max, Min, Avg, Total for every group