{"id":5317,"date":"2020-03-26T06:09:26","date_gmt":"2020-03-26T06:09:26","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=5317"},"modified":"2024-04-10T06:29:49","modified_gmt":"2024-04-10T06:29:49","slug":"ranking-using-calculated-field","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/","title":{"rendered":"Ranking using Calculated Field"},"content":{"rendered":"

How to use the rank function in Tableau<\/span><\/h2>\n

 <\/p>\n

Tableau Installation Tutorial for Beginners<\/strong>, are you looking for the information of tableau server installation steps under tableau course? Or the one who is casually glancing for the best platform which is providing information on how to install tableau software for beginners? Then you\u2019ve landed on the Right Platform which is packed with tons of tutorials of installation of tableau. Follow the below mentioned Tableau Installation tutorial for Beginners which were originally designed by the world-class Trainers of\u00a0Tableau Training institute<\/a>\u00a0Professionals.<\/p>\n

If you are the one who is a hunger to become the certified Pro\u00a0Tableau Developer<\/a>? Or the one who is looking for the best tableau Training institute which offering advanced tutorials and\u00a0tableau certification course<\/a>\u00a0to all the tech enthusiasts who are eager to learn the technology from starting Level to Advanced Level.<\/p>\n

Ranking is referred to as the position in a hierarchy. It is basically relative in nature.Finding ranks is one of the very important aspects of analytics. Rankings help in identifying the performance of the variables and thus help in prioritizing business actions and taking important business decisions.<\/p>\n

Let\u2019s explore how to find rankings in Tableau. Here, we have used Sample EU Superstore data which is provided by Tableau by default.<\/h4>\n

First, let us make a Text Tables Chart. Drag a Dimensions variable (here we have chosen Sub Category) to the Rows shelf and then drag a Measures variable (here we have selected Sales) to the Columns shelf. Then from Show Me section, click on Text Tables Chart<\/a> in order to make the chart. The arrows in the diagram below help in understanding the step. We have already taught how to make Text Table Chart. Please refer to the chapter for more details and customization.<\/p>\n

\"Calculated<\/p>\n

Now in order to find the ranks, we have to make a Calculated Field. We have already covered how to make Calculated Field. Please refer to the chapter for more details. However we would be brushing up the same again in this chapter.<\/p>\n

Click on the little arrow beside Dimensions and then click on Create Calculated Field<\/a>. The arrows in the diagram below show the step.<\/h4>\n

\"Calculated<\/p>\n

Now in the new window which appears, give a name of the Calculated Field (here, we have put the name as Rank). Then write the code as shown below in the diagram and choose the order as per requirement; \u2018asc\u2019 for ascending order and \u2018desc\u2019 for descending order. Here we have chosen the ascending order. Then click on Apply and further click on OK.<\/p>\n

\"Calculated<\/p>\n

The Calculated Field \u2018Rank\u2019 gets created in the Measures section as shown by the arrow in the diagram given below.<\/p>\n

\"Calculated<\/p>\n

Now drag the Calculated Field \u2018Rank\u2019 to the Text Tables Chart as shown by the arrow in the diagram below in order to add the Rank Column in the chart.<\/p>\n

\"Calculated<\/p>\n

The Rank gets added as one more column in Text Table Chart<\/a> which we have created. The diagram given below helps in understanding the following step.<\/p>\n

\"Calculated<\/p>\n

Again, we have sorted the Rank column in descending order to enhance the readability of the graph.Click on the Rank header. From the window which appears, click on sort descending icon. The diagram below explains the step.<\/p>\n

\"Calculated<\/p>\n

Finally the ranks get sorted in descending<\/a> order as shown in the diagram given below.<\/p>\n

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

How to use the rank function in Tableau   Tableau Installation Tutorial for Beginners, are you looking for the information of tableau server installation steps under tableau course? Or the one who is casually glancing for the best platform which is providing information on how to install tableau software for beginners? Then you\u2019ve landed on […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,1666],"tags":[512,1904,513,526],"class_list":["post-5317","post","type-post","status-publish","format-standard","hentry","category-tableau","category-tableau-calculations","tag-best-tableau-training-institutes-in-bangalore","tag-create-a-ranking-index-in-a-calculated-field","tag-tableau-training-in-bangalore","tag-tableau-training-institute-in-bangalore"],"acf":[],"yoast_head":"\nHow to use the rank function in Tableau - Prwatech<\/title>\n<meta name=\"description\" content=\"Master How to Use the Rank Function in Tableau - 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=\"How to use the rank function in Tableau - Prwatech\" \/>\n<meta property=\"og:description\" content=\"Master How to Use the Rank Function in Tableau - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/\" \/>\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-26T06:09:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-10T06:29:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11-1024x404.jpg\" \/>\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-calculations\/ranking-using-calculated-field\/\",\"url\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/\",\"name\":\"How to use the rank function in Tableau - Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11-1024x404.jpg\",\"datePublished\":\"2020-03-26T06:09:26+00:00\",\"dateModified\":\"2024-04-10T06:29:49+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master How to Use the Rank Function in Tableau - Dive deep with our expert instructors and comprehensive curriculum.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11.jpg\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11.jpg\",\"width\":1357,\"height\":536,\"caption\":\"Calculated Field Step by step implementation 1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ranking using Calculated Field\"}]},{\"@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":"How to use the rank function in Tableau - Prwatech","description":"Master How to Use the Rank Function in Tableau - 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":"How to use the rank function in Tableau - Prwatech","og_description":"Master How to Use the Rank Function in Tableau - Dive deep with our expert instructors and comprehensive curriculum.","og_url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2020-03-26T06:09:26+00:00","article_modified_time":"2024-04-10T06:29:49+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11-1024x404.jpg","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-calculations\/ranking-using-calculated-field\/","url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/","name":"How to use the rank function in Tableau - Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11-1024x404.jpg","datePublished":"2020-03-26T06:09:26+00:00","dateModified":"2024-04-10T06:29:49+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master How to Use the Rank Function in Tableau - Dive deep with our expert instructors and comprehensive curriculum.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11.jpg","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-11.jpg","width":1357,"height":536,"caption":"Calculated Field Step by step implementation 1"},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/ranking-using-calculated-field\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Ranking using Calculated Field"}]},{"@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\/5317","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=5317"}],"version-history":[{"count":3,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5317\/revisions"}],"predecessor-version":[{"id":11304,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5317\/revisions\/11304"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=5317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=5317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=5317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}