{"id":3166,"date":"2019-12-23T16:46:20","date_gmt":"2019-12-23T16:46:20","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3166"},"modified":"2024-05-17T01:54:05","modified_gmt":"2024-05-17T01:54:05","slug":"understanding-domain-aggregation","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/understanding-domain-aggregation\/","title":{"raw":"Understanding Domain Aggregation","rendered":"Understanding Domain Aggregation"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Discuss domain aggregation<\/li>\r\n<\/ul>\r\n<\/div>\r\nThere are twelve aggregate functions that extract and group data from a larger data set.\r\n<ul>\r\n \t<li style=\"font-weight: 400;\">DSum<\/li>\r\n \t<li style=\"font-weight: 400;\">DAvg<\/li>\r\n \t<li style=\"font-weight: 400;\">DCount<\/li>\r\n \t<li style=\"font-weight: 400;\">DLookup<\/li>\r\n \t<li style=\"font-weight: 400;\">DMin and DMax<\/li>\r\n \t<li style=\"font-weight: 400;\">DFirst and DLast<\/li>\r\n \t<li style=\"font-weight: 400;\">DStDev<\/li>\r\n \t<li style=\"font-weight: 400;\">DStDevP<\/li>\r\n \t<li style=\"font-weight: 400;\">DVar<\/li>\r\n \t<li style=\"font-weight: 400;\">DvarP<\/li>\r\n<\/ul>\r\nThese functions all have the same structure:\r\n<p style=\"padding-left: 30px;\">FunctionName( \u201c [Field Name] \u201c,\u201d [Dataset Name] \u201c, \u201c[Criteria] \u201c )<\/p>\r\n<strong>FunctionName<\/strong> is the name of the domain aggregation function being invoked;\u00a0 <strong>Field Name<\/strong> refers to the field containing the data in question; <strong>DataSet Name<\/strong> refers to the table in play; and, <strong>Criteria<\/strong> limits the inclusion of data per the scope necessary.\r\n\r\nThese functions can provide everything from a total of the values listed to an average of those values to the standard deviation of the values listed. The Help menu has detailed information about the functions.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/8c833634-88b1-4a4a-b6ab-42250092280c\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Discuss domain aggregation<\/li>\n<\/ul>\n<\/div>\n<p>There are twelve aggregate functions that extract and group data from a larger data set.<\/p>\n<ul>\n<li style=\"font-weight: 400;\">DSum<\/li>\n<li style=\"font-weight: 400;\">DAvg<\/li>\n<li style=\"font-weight: 400;\">DCount<\/li>\n<li style=\"font-weight: 400;\">DLookup<\/li>\n<li style=\"font-weight: 400;\">DMin and DMax<\/li>\n<li style=\"font-weight: 400;\">DFirst and DLast<\/li>\n<li style=\"font-weight: 400;\">DStDev<\/li>\n<li style=\"font-weight: 400;\">DStDevP<\/li>\n<li style=\"font-weight: 400;\">DVar<\/li>\n<li style=\"font-weight: 400;\">DvarP<\/li>\n<\/ul>\n<p>These functions all have the same structure:<\/p>\n<p style=\"padding-left: 30px;\">FunctionName( \u201c [Field Name] \u201c,\u201d [Dataset Name] \u201c, \u201c[Criteria] \u201c )<\/p>\n<p><strong>FunctionName<\/strong> is the name of the domain aggregation function being invoked;\u00a0 <strong>Field Name<\/strong> refers to the field containing the data in question; <strong>DataSet Name<\/strong> refers to the table in play; and, <strong>Criteria<\/strong> limits the inclusion of data per the scope necessary.<\/p>\n<p>These functions can provide everything from a total of the values listed to an average of those values to the standard deviation of the values listed. The Help menu has detailed information about the functions.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_8c833634-88b1-4a4a-b6ab-42250092280c\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/8c833634-88b1-4a4a-b6ab-42250092280c?iframe_resize_id=assessment_practice_id_8c833634-88b1-4a4a-b6ab-42250092280c\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3166\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Understanding Domain Aggregation. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":19,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Understanding Domain Aggregation\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"f92d00e2-b587-46e4-bff2-3cc40f9de00d, 9db30d66-8082-47d3-b9b1-b6e16ea5fdd2","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3166","chapter","type-chapter","status-publish","hentry"],"part":2775,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":8,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3166\/revisions"}],"predecessor-version":[{"id":5991,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3166\/revisions\/5991"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2775"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3166\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3166"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3166"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3166"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}