{"id":209,"date":"2022-06-09T19:40:21","date_gmt":"2022-06-09T19:40:21","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/aggregate-functions\/"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"aggregate-functions","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/aggregate-functions\/","title":{"rendered":"Aggregate Functions"},"content":{"rendered":"<ul>\n<li value=\"1\">Group data and add aggregate functions by selecting it from the Group By drop down field.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/31.png\" \/><\/p>\n<ul>\n<li value=\"1\">Change any other Group By aggregate function by selecting it from the drop down field.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":6,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/209"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/209\/revisions"}],"predecessor-version":[{"id":210,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/209\/revisions\/210"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Criteria - Filter","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/criteria-filter\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/211"}],"prev":[{"title":"Expression and Formulas","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}