{"id":11059,"date":"2018-03-17T09:11:39","date_gmt":"2018-03-17T09:11:39","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11059"},"modified":"2025-03-05T14:27:18","modified_gmt":"2025-03-05T08:57:18","slug":"tableau-type-conversion","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/","title":{"rendered":"Tableau Calculated Fields &#8211; Type Conversion"},"content":{"rendered":"<p>In this Tableau tutorial, we are going to study Tableau Calculated Fields &#8211; Type Conversion in Tableau, a stepwise procedure to Create Tableau Type Conversion of Calculated Fields, list of type conversion in tableau: DATE perform, FLOAT perform, INT perform, and STR perform with their expression &amp; example. So, let us start.<\/p>\n<h3>Tableau Type Conversion<\/h3>\n<p>This gathering of capacities enable you to take the consequence of any articulation and change over it to another particular information write. These are vital for setting up a few fields for estimation or for the situation that the basic information source needs a tad of readiness to get the most out of your perception.<br \/>\nThese are entirely straightforward, so allows simply hop right in!<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/\"><strong>Let&#8217;s study Tableau Calculated Fields &#8211; Logical Functions in Tableau<\/strong><\/a><\/p>\n<h3>Create a Type Conversion<\/h3>\n<p>How to build Type Conversion\u00a0in\u00a0Tableau Calculated Fields.<\/p>\n<p>i. In Tableau Desktop, connect with the Sample &#8211; Superstore saved information supply, that comes with Tableau.<\/p>\n<p>ii. Navigate to a worksheet.<\/p>\n<p>iii. Select <strong>Analysis &gt; produce Calculated Field<\/strong>.<\/p>\n<p>iv. In the calculation editor that opens, do the following:<\/p>\n<ul>\n<li>Name the calculated field, postcode String.<\/li>\n<li>Enter the subsequent formula:<\/li>\n<\/ul>\n<h4>STR([Postal Code])<\/h4>\n<ul>\n<li>This calculation converts the postcode field from variety to a string.<\/li>\n<\/ul>\n<p>When finished, click OK.<\/p>\n<p>The new calculated field seems underneath dimensions within the information pane. rather like your alternative fields, you&#8217;ll use it in one or a lot of visualizations.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/aggregate-functions\/\"><strong>Read about\u00a0Tableau Calculated Fields &#8211; Tableau Aggregate Functions\u00a0<\/strong><\/a><\/p>\n<p>Converting this field from variety to a string ensures that Tableau treats it as a string and not variety (i.e. Tableau doesn&#8217;t mixture it.<\/p>\n<h3>List of Type Conversion in Tableau<\/h3>\n<p>There are eight types of Tableau Type Conversion let&#8217;s see some of them one by one:<\/p>\n<div id=\"attachment_11064\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/2018-03-17.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11064\" class=\"wp-image-11064 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/2018-03-17.png\" alt=\"Tableau Type Conversion\" width=\"624\" height=\"222\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/2018-03-17.png 624w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/2018-03-17-150x53.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/2018-03-17-300x107.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><p id=\"caption-attachment-11064\" class=\"wp-caption-text\">Tableau Type Conversion<\/p><\/div>\n<h4>a. DATE perform<\/h4>\n<p>DATE(expression)<\/p>\n<p>The Date performs converts variety, string or date expression into a date. Here\u2019s associate degree example:<br \/>\nDATE(\u201c10 January 2015\u201d) = #January fifteen, 2015#<br \/>\nDATETIME perform<br \/>\nDATETIME(expression)<\/p>\n<p>Similar to the Date perform higher than, the DateTime perform takes it a step more by returning a time element. Again, you&#8217;ll come a DateTime from a date, variety or string. Here\u2019s associate degree example:<br \/>\nDATETIME(\u201c10 January 2015\u201d) = #January fifteen, 2015 12:00:00 AM#<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/tableau-date-functions\/\"><strong>Let&#8217;s discuss\u00a0Tableau Calculated Fields- Tableau Date Functions\u00a0<\/strong><\/a><\/p>\n<h4>b. FLOAT perform<\/h4>\n<p>FLOAT(expression)<\/p>\n<p>The Float performs converts its argument into a floating purpose variety. Here&#8217;s associate degree example:<br \/>\nFLOAT(3) = three.000<\/p>\n<h4>c. INT perform<\/h4>\n<p>INT(expression)<\/p>\n<p>The INT perform returns its argument as associate degree whole number. For expressions, the INT perform truncates results to the nearest whole number towards zero. Here&#8217;s associate degree example:<br \/>\nINT(-10.7) = -10<br \/>\nLet&#8217;s look at\u00a0String Functions in Tableau<\/p>\n<h4>d. STR perform<\/h4>\n<p>STR(expression)<\/p>\n<p>This performance can come to the argument because of the string knowledge kind. Here\u2019s associate degree example:<br \/>\nSTR(45) = \u201c45\u201d<\/p>\n<p>Using these functions, you&#8217;ll convert totally {different|completely different} arguments to different knowledge varieties. If you would like to confirm that each one of the values during a date field are so thought of date or date-time knowledge varieties, then you&#8217;ll use the Date or DateTime perform to try and do, therefore.<\/p>\n<h3>Conclusion<\/h3>\n<p>Hence, in this Tableau tutorial, we learned about Type Conversion in Tableau Calculated Fields, how to create Tableau Type Conversion. In conclusion, how to use them with examples thus completing another table on our list. Furthermore, if you have any query, feel free to ask in comment session.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this Tableau tutorial, we are going to study Tableau Calculated Fields &#8211; Type Conversion in Tableau, a stepwise procedure to Create Tableau Type Conversion of Calculated Fields, list of type conversion in tableau:&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":11065,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[3047,3561,4796,6847,13882,14185,14190,14238,14239,14279,14318,14441,14463,14997,14999],"class_list":["post-11059","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-create-a-type-conversion","tag-date-perform","tag-float-perform","tag-int-perform","tag-str-perform","tag-tableau-calculated-fields","tag-tableau-change-data-type","tag-tableau-date-to-string-format","tag-tableau-dateparse","tag-tableau-float-data-type","tag-tableau-isnumeric","tag-tableau-str-function","tag-tableau-type-conversion","tag-type-conversion","tag-type-conversion-in-tableau"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tableau Calculated Fields - Type Conversion - DataFlair<\/title>\n<meta name=\"description\" content=\"Tableau Calculated Fields-Type Conversion, list of Type Conversion in tableau, DATE perform, FLOAT perform, INT &amp; STR perform\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Calculated Fields - Type Conversion - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Tableau Calculated Fields-Type Conversion, list of Type Conversion in tableau, DATE perform, FLOAT perform, INT &amp; STR perform\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-17T09:11:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-05T08:57:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Calculated Fields - Type Conversion - DataFlair","description":"Tableau Calculated Fields-Type Conversion, list of Type Conversion in tableau, DATE perform, FLOAT perform, INT & STR perform","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Calculated Fields - Type Conversion - DataFlair","og_description":"Tableau Calculated Fields-Type Conversion, list of Type Conversion in tableau, DATE perform, FLOAT perform, INT & STR perform","og_url":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-17T09:11:39+00:00","article_modified_time":"2025-03-05T08:57:18+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Calculated Fields &#8211; Type Conversion","datePublished":"2018-03-17T09:11:39+00:00","dateModified":"2025-03-05T08:57:18+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/"},"wordCount":589,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg","keywords":["Create a Type Conversion","DATE perform","FLOAT perform","INT perform","STR perform","Tableau Calculated Fields","tableau change data type","tableau date to string format","tableau dateparse","tableau float data type","tableau isnumeric","tableau str function","Tableau Type Conversion","Type Conversion","Type Conversion in tableau"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/","url":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/","name":"Tableau Calculated Fields - Type Conversion - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg","datePublished":"2018-03-17T09:11:39+00:00","dateModified":"2025-03-05T08:57:18+00:00","description":"Tableau Calculated Fields-Type Conversion, list of Type Conversion in tableau, DATE perform, FLOAT perform, INT & STR perform","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Tableau-Calculated-Fields-01.jpg","width":1200,"height":628,"caption":"Tableau Calculated Fields - Type Conversion"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-type-conversion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Tableau Calculated Fields &#8211; Type Conversion"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=11059"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11059\/revisions"}],"predecessor-version":[{"id":144465,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11059\/revisions\/144465"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11065"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}