{"id":1663,"date":"2020-02-05T20:45:09","date_gmt":"2020-02-06T01:45:09","guid":{"rendered":"https:\/\/www.foxquestsystems.net\/foxblog\/?p=1663"},"modified":"2020-02-06T08:23:32","modified_gmt":"2020-02-06T13:23:32","slug":"multi-level-filtering","status":"publish","type":"post","link":"https:\/\/www.foxquestsystems.net\/foxblog\/2020\/02\/05\/multi-level-filtering\/","title":{"rendered":"Multi-Level Filtering"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Filter option is probably the Scheduler\u2019s most powerful\ntool in P6. The Filter option allows the Scheduler to display only specific\nactivities based on the Filter criteria. There are a vast amount of options\nthat go beyond the scope of this article.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, in this article, we will explore a not-well known or understood feature I&#8217;ll describe as \u201cMulti-Leveling\u201d. In other words, you can implement the multi-level filter technique that allows for multiple filter criteria to be combined into a single Filter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the sample Project shown below, \u201cThyme Street Bridge\nConstruction\u201d consists of the construction 3 Piers comprised of Piles, Footers,\nColumns and Caps. The Project is planned with 3 crews: a) a Pile Driving Crew;\nB) a Footer Construction Crew; and C) a Carpenter Crew responsible for building\nthe Columns and Caps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this scenario, a reasonable CPM model for this Project would appear as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Sample-Project-All-Activities.jpg?resize=840%2C252&#038;ssl=1\" alt=\"\" class=\"wp-image-1675\" width=\"840\" height=\"252\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Sample-Project-All-Activities.jpg?resize=1024%2C307&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Sample-Project-All-Activities.jpg?resize=300%2C90&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Sample-Project-All-Activities.jpg?resize=768%2C230&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Sample-Project-All-Activities.jpg?w=1174&amp;ssl=1 1174w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now suppose we need to display\n(or Filter) only the Cap construction for Piers 1 and Piers 3. Since the sample\nset above is small, there are multiple options to accomplish this. However, for\nthe purposes of illustration, the most common solution would be to create 2\nFilters. One filter to select only the Cap Construction, then another to select\nPiers 1 and Piers 2. Once the 2 independent Filters are defined, the option to\n\u201cShow activities that match\u201d is set to \u201cAll selected filters\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The common solution approach\nconsists of:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create a Filter to Select only Cap Construction as shown below:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"626\" height=\"370\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1.-Cap-Construction.jpg?resize=626%2C370&#038;ssl=1\" alt=\"\" class=\"wp-image-1669\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1.-Cap-Construction.jpg?w=626&amp;ssl=1 626w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1.-Cap-Construction.jpg?resize=300%2C177&amp;ssl=1 300w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Filter shown above uses the \u201c(All of the following)\u201d option to select only activities containing the word \u201cCap\u201d.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create a Filter to Select Pier 1 or Pier 3 Construction as shown below:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-2.-Pier-1-and-Pier-3-Construction.jpg?resize=626%2C369&#038;ssl=1\" alt=\"\" class=\"wp-image-1670\" width=\"626\" height=\"369\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-2.-Pier-1-and-Pier-3-Construction.jpg?w=626&amp;ssl=1 626w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-2.-Pier-1-and-Pier-3-Construction.jpg?resize=300%2C177&amp;ssl=1 300w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Filter shown above uses the \u201c(Any of the following)\u201d option to select only activities containing the word \u201cPier 1\u201d or \u201cPier 3\u201d.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Under the \u201cShow activities that match\u201d text, select the \u201cAll selected filters\u201d option, then select both Filters created above as shown below:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected.jpg?resize=496%2C475&#038;ssl=1\" alt=\"\" class=\"wp-image-1668\" width=\"496\" height=\"475\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected.jpg?w=496&amp;ssl=1 496w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected.jpg?resize=300%2C287&amp;ssl=1 300w\" sizes=\"auto, (max-width: 496px) 85vw, 496px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The results of the 2 Filter selection criteria are correctly shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected-and-Executed-1024x133.jpg?resize=840%2C109&#038;ssl=1\" alt=\"\" class=\"wp-image-1667\" width=\"840\" height=\"109\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected-and-Executed.jpg?resize=1024%2C133&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected-and-Executed.jpg?resize=300%2C39&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected-and-Executed.jpg?resize=768%2C100&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-1-and-2-Selected-and-Executed.jpg?w=1110&amp;ssl=1 1110w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The above solution is correct and operative, however, with the use of Multi-level Filtering, a better and more efficient solution can be constructed by combining both Filters into one Filter Criteria as shown below.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create the first Filter criteria exactly as in Step 1 above as shown below:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Step-1-Cap-Construction.jpg?resize=622%2C368&#038;ssl=1\" alt=\"\" class=\"wp-image-1672\" width=\"622\" height=\"368\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Step-1-Cap-Construction.jpg?w=622&amp;ssl=1 622w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Step-1-Cap-Construction.jpg?resize=300%2C177&amp;ssl=1 300w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Next, Include the next criteria similar to Step 2 above: <ul><li>Add a third line using the \u201c(Any of the following)\u201d option similar to Step 2 above.<\/li><\/ul><ul><li>Add a fourth line, then enter the criteria \u201cWhere Activity Name contains Pier 1\u201d. Make sure that Line 3 as shown below contains the \u201c-\u201c symbol on the left indicating a <strong>second level<\/strong> is defined for the filter criteria. If the \u201c-\u201c symbol is not shown, then click on the \u201cShift Right\u201d arrow to create the second level. Notice also that the second \u201c-\u201c symbol is indented indicating the second level criteria.<\/li><\/ul><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-4.jpg?resize=627%2C369&#038;ssl=1\" alt=\"\" class=\"wp-image-1664\" width=\"627\" height=\"369\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-4.jpg?w=627&amp;ssl=1 627w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-4.jpg?resize=300%2C177&amp;ssl=1 300w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Add the fifth and final line, then enter the\ncriteria \u201cWhere Activity Name contains Pier 3\u201d. Make sure line 5 begins with\n\u201cOr\u201d. When done, select OK.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-5.jpg?resize=628%2C368&#038;ssl=1\" alt=\"\" class=\"wp-image-1665\" width=\"628\" height=\"368\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-5.jpg?w=628&amp;ssl=1 628w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Both-Filter-1-and-2-Selected-Adding-Line-5.jpg?resize=300%2C176&amp;ssl=1 300w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The results of the 1 Filter\nselection criteria are correctly shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Selected-and-Executed-1024x144.jpg?resize=840%2C118&#038;ssl=1\" alt=\"\" class=\"wp-image-1671\" width=\"840\" height=\"118\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Selected-and-Executed.jpg?resize=1024%2C144&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Selected-and-Executed.jpg?resize=300%2C42&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Selected-and-Executed.jpg?resize=768%2C108&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Filter-3-Selected-and-Executed.jpg?w=1088&amp;ssl=1 1088w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This solution is more efficient since only 1 Filter used\neliminating the need to specify the \u201cShow activities that match\u201d option.&nbsp; <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In conclusion, this simple example shows that the Filter option is more robust than what may initially appear. If necessary, additional levels can be added for more complicated Filters. The best way to improve your proficiency with Filters is to experiment with known results thereby better understanding its structure and behavior.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Copyright \u00a92020 FoxQuest Systems, Inc. &#8211; All Rights Reserved<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Take your Filtering skills to the next level&#8230;<\/p>\n","protected":false},"author":2,"featured_media":1673,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[12],"tags":[],"class_list":["post-1663","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/Multi-Level-Filtering-Feature-Image.jpg?fit=497%2C473&ssl=1","_links":{"self":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/comments?post=1663"}],"version-history":[{"count":4,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1663\/revisions"}],"predecessor-version":[{"id":1679,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1663\/revisions\/1679"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media\/1673"}],"wp:attachment":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media?parent=1663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/categories?post=1663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/tags?post=1663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}