Author Topic: Display grouping data such as Max, Min, Avg, Total for every group  (Read 2363 times)

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
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

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
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?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
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

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
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 »