{"id":5130,"date":"2020-03-12T13:24:53","date_gmt":"2020-03-12T13:24:53","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=5130"},"modified":"2024-04-11T06:02:18","modified_gmt":"2024-04-11T06:02:18","slug":"group-hierarchy-and-sort-data","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/","title":{"rendered":"Group, Hierarchy and Sort Data"},"content":{"rendered":"

Advanced sorting: hierarchical sorting<\/span><\/h2>\n

 <\/p>\n

Let\u2019s explore how to Sort and Group data<\/a> along with the creation of Hierarchies. We have used the Sample EU Superstore data set which is provided by Tableau by default. Let\u2019s explore them one by one.<\/p>\n

Creating Groups on Tableau<\/strong><\/p>\n

Simplification of dimension levels into higher level sub-groups is referred to as Grouping. <\/strong>It helps in highlighting of multiple data points or header names.<\/p>\n

Right click on Category variable from the Dimensions section. Then click on Create from the drop down menu and click on group as shown by the arrows in the diagram below :<\/p>\n

\"Creting<\/p>\n

Select the components in the group. Here, we have selected Furniture and Office Supplies by clicking \u2018ctrl\u2019 from the variable Category and then click on \u2018Group\u2019 and thereafter \u2018OK\u2019. The diagram below shows the step.<\/p>\n

\"Tableau<\/p>\n

The group is now created out of Category as pointed by the arrow in the diagram below.<\/p>\n

\"Step<\/p>\n

Let\u2019s create a visualisation for the same. Drag the group created [Category (group)] from Dimensions section to Columns and Sales from Measures section to Rows and click on bars from \u2018Show Me\u2019. The diagram below shows that the graph contains only the components selected in the sub group.<\/p>\n

\"Tableau<\/p>\n

Let\u2019s move on to next topic.<\/p>\n

Sorting of Data<\/strong><\/p>\n

The re-organisation of data into a meaningful order for better understanding and analysis of data is known as sorting of data.<\/strong><\/p>\n

Data can be sort from the sort options given at the top. Just by clicking on either of the ascending or descending order sort option, the data or the graph can get sort. The below diagram explains the step.<\/p>\n

\"tableau<\/p>\n

We have clicked on the descending sort option and the diagram below shows the result.<\/h4>\n

\"Tableau<\/p>\n

We can also do it in a different way. Select Sub Category and Quantity simultaneously and click on Text Tables chart. Then right click on sub category from rows and click on \u2018sort\u2019 as shown in the diagram below.<\/p>\n

\"tableau<\/p>\n

Go to Sort By and click on the little arrow and from the drop down list, click on field. Also, explore the other options as well. The diagram below explains the step.<\/p>\n

\"Tableau<\/p>\n

Now click on Descending or Ascending from Sort Order as shown below in the diagram.<\/p>\n

\"Tableau<\/p>\n

The values would get arrange in descending order as per the values of Quantity. The diagram below demonstrates the step.<\/p>\n

\"Tableau<\/p>\n

Let\u2019s now move on to the last topic, i.e., Hierarchy<\/strong><\/p>\n

Hierarchy<\/strong><\/p>\n

Right click on Category, select Hierarchy, and click on Create Hierarchy as shown in the diagram below.<\/p>\n

\"Tableau<\/p>\n

Again, right click on Sun Category, click on Hierarchy<\/a> and then click and Add to Hierarchy and then select Category as shown in the diagram below.<\/p>\n

\"Tableau<\/p>\n

The Hierarchy of Category and Sub Category is created as shown below in the diagram.<\/p>\n

\"Tableau<\/p>\n","protected":false},"excerpt":{"rendered":"

Advanced sorting: hierarchical sorting   Let\u2019s explore how to Sort and Group data along with the creation of Hierarchies. We have used the Sample EU Superstore data set which is provided by Tableau by default. Let\u2019s explore them one by one. Creating Groups on Tableau Simplification of dimension levels into higher level sub-groups is referred […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,1680],"tags":[512,514,1947,511,1948,1949,513],"class_list":["post-5130","post","type-post","status-publish","format-standard","hentry","category-tableau","category-tableau-groups","tag-best-tableau-training-institutes-in-bangalore","tag-best-tableau-training-institutes-in-pune","tag-create-groups","tag-creating-groups-on-tableau","tag-hierarchy","tag-sets-sort-data-tableau","tag-tableau-training-in-bangalore"],"acf":[],"yoast_head":"\nAdvanced sorting: hierarchical sorting - Prwatech<\/title>\n<meta name=\"description\" content=\"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced sorting: hierarchical sorting - Prwatech\" \/>\n<meta property=\"og:description\" content=\"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-12T13:24:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-11T06:02:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1024x474.png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/\",\"url\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/\",\"name\":\"Advanced sorting: hierarchical sorting - Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1024x474.png\",\"datePublished\":\"2020-03-12T13:24:53+00:00\",\"dateModified\":\"2024-04-11T06:02:18+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1.png\",\"width\":1360,\"height\":629,\"caption\":\"Creting groups for tableau\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Group, Hierarchy and Sort Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced sorting: hierarchical sorting - Prwatech","description":"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Advanced sorting: hierarchical sorting - Prwatech","og_description":"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.","og_url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2020-03-12T13:24:53+00:00","article_modified_time":"2024-04-11T06:02:18+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1024x474.png","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/","url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/","name":"Advanced sorting: hierarchical sorting - Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1024x474.png","datePublished":"2020-03-12T13:24:53+00:00","dateModified":"2024-04-11T06:02:18+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master Advanced Sorting: Hierarchical Sorting - Dive deep with our expert instructors and comprehensive curriculum.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1.png","width":1360,"height":629,"caption":"Creting groups for tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-groups\/group-hierarchy-and-sort-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Group, Hierarchy and Sort Data"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=5130"}],"version-history":[{"count":4,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5130\/revisions"}],"predecessor-version":[{"id":11329,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5130\/revisions\/11329"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=5130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=5130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=5130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}