{"id":8796,"date":"2024-12-12T12:15:24","date_gmt":"2024-12-12T10:15:24","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=8796"},"modified":"2024-12-12T12:15:24","modified_gmt":"2024-12-12T10:15:24","slug":"agregatni-funkcziyi","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zvit-interaktyvnyj-deshbord\/agregatni-funkcziyi\/","title":{"rendered":"Aggregations"},"content":{"rendered":"<p>In the interactive dashboard, the following aggregate functions are available:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_24_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8799\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_24_1-2.png\" alt=\"\" width=\"398\" height=\"459\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_24_1-2.png 398w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_24_1-2-390x450.png 390w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_24_1-2-260x300.png 260w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<ul>\n<li>Count \u2013 returns the number of values<\/li>\n<li>Count Distinct \u2013 returns the number of distinct values<\/li>\n<li>Sum \u2013 returns the sum of all values<\/li>\n<li>Min \u2013 returns the minimum value across all records<\/li>\n<li>Max \u2013 returns the maximum value across all records<\/li>\n<li>Average \u2013 Returns the average of all the values in the<\/li>\n<li>StdDev \u2013 Mean Square Deviation<\/li>\n<li>StdDev P \u2013 dispersion<\/li>\n<li>Var \u2013 Non-shifted dispersion<\/li>\n<li>VarP \u2013 returns the variance of a population where the population is the entire data to be summarized.<\/li>\n<li>Median<\/li>\n<li>Mode<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":4864,"menu_order":279,"template":"","manuals":[17],"class_list":["post-8796","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/8796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4864"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=8796"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=8796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}