{"id":5159,"date":"2020-03-14T05:51:52","date_gmt":"2020-03-14T05:51:52","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=5159"},"modified":"2024-04-09T10:38:31","modified_gmt":"2024-04-09T10:38:31","slug":"calculated-field-get-started-with-calculations-in-tableau","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/","title":{"rendered":"Calculated Field"},"content":{"rendered":"

Get Started with Calculations in Tableau<\/span><\/h2>\n

 <\/p>\n

Calculated fields are one of the most powerful features of Tableau<\/a> which allows to create new data from existing data set. It can be used to make new measures such as ratios or even new dimensions such as segments. Calculated fields can also be used with any data type, aggregations and functions, as well as logical operators.<\/p>\n

Let\u2019s learn how to make Calculated Fields in the following steps. Here, we have used Samples EU Superstore data which is provided by Tableau by default.<\/p>\n

Click on the little arrow beside Dimensions as shown by the arrow in the diagram given below. Then click on Create Calculated Field.<\/p>\n

\"Calculated<\/p>\n

On clicking the Create Calculated Field, the following window appears as shown by the diagram below.\u00a0 the right hand side, the functions list appears and on clicking on them, the definition of the function is given. On top left, the name of the Calculated Field is to be put and below it, the formulae are written.<\/p>\n

\"Calculated<\/p>\n

As the figure above shows, we have written the function for Total Sales as SUM ([Sales]).<\/strong>Then click on OK. And then the Calculated Field gets create as shown in the diagram below.<\/p>\n

\"Calculated<\/p>\n

We can check the value of Total Sales by dragging it from Measures Section to Text in the Marks Card. The diagram below demonstrates the step.<\/h4>\n

\"claculated<\/p>\n

We can also edit the Calculated Field created. Select the Calculated Field, here, Total Sales. Then click on the little arrow beside it and click on Edit as shown by the arrow in the diagram.<\/p>\n

\"Calculated<\/p>\n

Then change the name of the Calculated Field, here, we have changed Total Sales to Average Sales. And also, change the function written to AVG ([Sales])\u00a0<\/strong>and click on OK.\u00a0\u00a0<\/strong>The diagram below demonstrates the step.<\/p>\n

\"Calculated<\/p>\n

The Calculated Field Total Sales<\/strong> gets changed to Average Sales <\/strong>along with the change of calculations in the functions as well.\u00a0 Then in order to check the value of Average Sales, drag Average Sales from Measures to Text in the Marks Card. The diagram below shows the following step.<\/p>\n

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

Get Started with Calculations in Tableau   Calculated fields are one of the most powerful features of Tableau which allows to create new data from existing data set. It can be used to make new measures such as ratios or even new dimensions such as segments. Calculated fields can also be used with any data […]<\/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":[1902,516,517,515,1903],"class_list":["post-5159","post","type-post","status-publish","format-standard","hentry","category-tableau","category-tableau-calculations","tag-calculating-fields-in-tableau-tutorial","tag-create-custom-fields-with-calculations","tag-tableau-calcualted-field","tag-what-is-calculated-field-in-tableau","tag-when-to-use-calculated-columns-and-calculated-fields"],"acf":[],"yoast_head":"\nGet Started with Calculations in Tableau - Prwatech<\/title>\n<meta name=\"description\" content=\"Master Get Started with Calculations 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=\"Get Started with Calculations in Tableau - Prwatech\" \/>\n<meta property=\"og:description\" content=\"Master Get Started with Calculations in Tableau - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/\" \/>\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-14T05:51:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-09T10:38:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1-1024x467.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=\"3 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\/calculated-field-get-started-with-calculations-in-tableau\/\",\"url\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/\",\"name\":\"Get Started with Calculations in Tableau - Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1-1024x467.jpg\",\"datePublished\":\"2020-03-14T05:51:52+00:00\",\"dateModified\":\"2024-04-09T10:38:31+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master Get Started with Calculations in Tableau - Dive deep with our expert instructors and comprehensive curriculum.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1.jpg\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1.jpg\",\"width\":1360,\"height\":620,\"caption\":\"Calculated Field Step by step implementation 1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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":"Get Started with Calculations in Tableau - Prwatech","description":"Master Get Started with Calculations 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":"Get Started with Calculations in Tableau - Prwatech","og_description":"Master Get Started with Calculations in Tableau - Dive deep with our expert instructors and comprehensive curriculum.","og_url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2020-03-14T05:51:52+00:00","article_modified_time":"2024-04-09T10:38:31+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1-1024x467.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/","url":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/","name":"Get Started with Calculations in Tableau - Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1-1024x467.jpg","datePublished":"2020-03-14T05:51:52+00:00","dateModified":"2024-04-09T10:38:31+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master Get Started with Calculations in Tableau - Dive deep with our expert instructors and comprehensive curriculum.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1.jpg","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2020\/03\/Step-by-step-implementation-1-1.jpg","width":1360,"height":620,"caption":"Calculated Field Step by step implementation 1"},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/tableau\/tableau-calculations\/calculated-field-get-started-with-calculations-in-tableau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"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\/5159","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=5159"}],"version-history":[{"count":4,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5159\/revisions"}],"predecessor-version":[{"id":11302,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/5159\/revisions\/11302"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=5159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=5159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=5159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}