{"id":2722,"date":"2024-01-09T15:51:12","date_gmt":"2024-01-09T13:51:12","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=2722"},"modified":"2024-09-20T14:54:25","modified_gmt":"2024-09-20T11:54:25","slug":"filtruvannya-vybirky-elementiv","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zmina-zvitiv\/vybirka-elementiv\/filtruvannya-vybirky-elementiv\/","title":{"rendered":"Filtering of Selected Elements"},"content":{"rendered":"<p>You can filter those elements which you\u2019ve selected on the tab \u201cSelection\u201d. There is a second tab \u201cFilter\u201d which is used for this.<\/p>\n<p>Let us make an example: let us choose all mountain bikes which are in the top 10 by the sum of sales in the first quarter of 2017. In order to select them, please do the following.<\/p>\n<p>Choose all bicycles:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2736\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_27.png\" alt=\"\" width=\"462\" height=\"174\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_27.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_27-450x169.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_27-300x113.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>Create a new filtering group on the tab \u201cFilter\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2737\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_28.png\" alt=\"\" width=\"462\" height=\"124\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_28.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_28-450x121.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_28-300x81.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>Fill in the data in order to select top 10 as shown on the following picture:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4980\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_2.png\" alt=\"\" width=\"462\" height=\"606\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_2.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_2-343x450.png 343w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_2-229x300.png 229w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>In order to make so that the \u201cReseller Sales Amount\u201d is to be computed using the 1<sup>st<\/sup> quarter of 2017 (but not all the time) you have to override context: press the button \u201cOverride Context for Hierarchy\u2026\u201d<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2739\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_30.png\" alt=\"\" width=\"434\" height=\"328\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_30.png 434w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_30-300x227.png 300w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><\/a><\/p>\n<p>Choose the time hierarchy:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_31.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2740\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_31.png\" alt=\"\" width=\"282\" height=\"129\" \/><\/a><\/p>\n<p>Choose the 1<sup>st<\/sup> quarter of 2017:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2741\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_32.png\" alt=\"\" width=\"181\" height=\"359\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_32.png 181w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_32-151x300.png 151w\" sizes=\"auto, (max-width: 181px) 100vw, 181px\" \/><\/a><\/p>\n<p>After pressing \u00abOK\u00bb you will get this:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2742\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_33.png\" alt=\"\" width=\"428\" height=\"324\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_33.png 428w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_33-300x227.png 300w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><\/a><\/p>\n<p>Add one more filtering condition:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2743\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_34.png\" alt=\"\" width=\"462\" height=\"242\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_34.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_34-450x236.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_34-300x157.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>In order to filter only mountain bikes fill in the following form:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_35.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2744\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_35.png\" alt=\"\" width=\"435\" height=\"222\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_35.png 435w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_35-300x153.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/a><\/p>\n<p>All filtering conditions are set. In order to make so that both conditions are applied to selected members, you have to select the \u201cAnd\u201d join type:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_36-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2749\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_36-1.png\" alt=\"\" width=\"462\" height=\"242\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_36-1.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_36-1-450x236.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_36-1-300x157.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>If you apply this filter, you will see the expected result:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2746\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_37.png\" alt=\"\" width=\"336\" height=\"113\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_37.png 336w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_37-300x101.png 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/a><\/p>\n<p>In the first condition you applied filtering by measure. In the second \u2013 using a property.<\/p>\n<p>When you\u2019re filtering by measure value, you can select one of the following conditions:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_38.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2747\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_38.png\" alt=\"\" width=\"435\" height=\"343\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_38.png 435w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_38-300x237.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/a><\/p>\n<p>The list of available conditions:<\/p>\n<ul>\n<li>Topmost members whose sum &gt;= X% of the total;<\/li>\n<li>Smallest members whose sum &gt;= X% of the total;<\/li>\n<li>Topmost members whose sum &gt;= X;<\/li>\n<li>Smallest members whose sum &gt;= X;<\/li>\n<li>Members with value = \u0425;<\/li>\n<li>Members with value &lt;&gt; \u0425;<\/li>\n<li>Members with value &gt; \u0425;<\/li>\n<li>Members with value &gt;= \u0425;<\/li>\n<li>Members with value &lt; \u0425;<\/li>\n<li>Members with value &lt;= \u0425;<\/li>\n<li>Members with value in the range from X to Y;<\/li>\n<li>Topmost X members;<\/li>\n<li>Smallest X members;<\/li>\n<\/ul>\n<p>If you filter elements by property, the list of conditions depends on the type of the property: is it text, numeric or date.<\/p>\n<p>If the property type is numeric or date, the list of conditions is identical to the list for measure.<\/p>\n<p>If the property is of text type, the list of conditions is as following:<\/p>\n<ul>\n<li>Members with values satisfying mask (the mask is case insensitive; you can use symbol \u00ab*\u00bb in the beginning and in the end of the mask);<\/li>\n<li>Members with values = \u0425;<\/li>\n<li>Members with values &lt;&gt; \u0425;<\/li>\n<li>Members with values &gt; \u0425;<\/li>\n<li>Members with values &gt;= \u0425;<\/li>\n<li>Members with values &lt; \u0425;<\/li>\n<li>Members with values &lt;= \u0425;<\/li>\n<li>Members with values in range between X and Y;<\/li>\n<li>Topmost X values;<\/li>\n<li>Smallest X values.<\/li>\n<\/ul>\n<p>It is possible to change filter status:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_39.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2748\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_39.png\" alt=\"\" width=\"462\" height=\"84\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_39.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_39-450x82.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/4_39-300x55.png 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":2675,"menu_order":73,"template":"","manuals":[17],"class_list":["post-2722","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2722","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\/2675"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=2722"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=2722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}