{"id":7080,"date":"2024-08-14T13:38:54","date_gmt":"2024-08-14T10:38:54","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7080"},"modified":"2024-08-14T13:43:04","modified_gmt":"2024-08-14T10:43:04","slug":"sortuvannya","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/sortuvannya\/","title":{"rendered":"Sorting"},"content":{"rendered":"<p>Let us sort the table obtained earlier in the decreasing order of the \u201cOrder Count\u201d measure.<\/p>\n<p>For this, click in the right corner of the table next to an icon:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_1-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7098\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_1-2.png\" alt=\"\" width=\"445\" height=\"123\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_1-2.png 445w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_1-2-300x83.png 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/a><\/p>\n<p>The column with the \u201cOrder Count\u201d measure is sorted in a descending order:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_2-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7097\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_2-2.png\" alt=\"\" width=\"445\" height=\"502\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_2-2.png 445w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_2-2-399x450.png 399w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_2-2-266x300.png 266w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/a><\/p>\n<p>Having clicked again, we get the opposite result (an increase of the \u201cOrder Count\u201d measure).<\/p>\n<p>To sort the hierarchy alphabetically, you need to open the context menu:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_3-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7096\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_3-2.png\" alt=\"\" width=\"273\" height=\"276\" \/><\/a><\/p>\n<p>By selecting the \u201cSort Descending\u201d method, we get a table with category names sorted in a descending order:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_4-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7095\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_4-2.png\" alt=\"\" width=\"444\" height=\"501\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_4-2.png 444w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_4-2-399x450.png 399w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_4-2-266x300.png 266w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/a><\/p>\n<p>If necessary, you can disable sorting:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_5-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7094\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_5-2.png\" alt=\"\" width=\"273\" height=\"273\" \/><\/a><\/p>\n<p>OLAP Sorting specific (in\u00a0OLAP\u00a0mode, you can use the following options to specify the sort order for attribute members):<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_6-2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7093\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_6-2.png\" alt=\"\" width=\"404\" height=\"273\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_6-2.png 404w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_23_6-2-300x203.png 300w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/a><\/p>\n<ul>\n<li>(Value) \u2013 sorting is performed by member values;<\/li>\n<li>(Display Text) \u2013 sorting is performed by captions associated with members;<\/li>\n<li>(Key) \u2013 sorting is performed by member keys;<\/li>\n<li>(ID) \u2013 sorting is performed by member<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":5521,"menu_order":530,"template":"","manuals":[18],"class_list":["post-7080","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7080","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=7080"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}