{"id":7264,"date":"2024-08-15T12:29:22","date_gmt":"2024-08-15T09:29:22","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7264"},"modified":"2024-08-15T12:29:22","modified_gmt":"2024-08-15T09:29:22","slug":"agregatni-funkcziyi","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/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\/08\/9_27_1-1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7265\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_27_1-1.png\" alt=\"\" width=\"403\" height=\"512\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_27_1-1.png 403w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_27_1-1-354x450.png 354w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_27_1-1-236x300.png 236w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/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>StdDevP \u2013 dispersion<\/li>\n<li>Var \u2013 Non-shifted dispersion<\/li>\n<li>VarP \u2013 median Mode<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":5521,"menu_order":537,"template":"","manuals":[18],"class_list":["post-7264","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7264","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\/5521"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7264"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}