Tableau Data Types

Data type:

A data type is a characterization that determines which kind of variable it is and what type of numerical, social or logical operations can be connected to it without causing a mistake. For example a string is a data type that is utilized to classify text and a integer which is a data type used to classify whole numbers.

Tableau supports Boolean data types, string, number, and date/date time. These data types are automatically added in a correct Fashion. However if you create calculated fields of your own, you should know how to utilize and combine the distinctive data types. For example, you can’t add a string to a number. Additionally, many functions that are accessible to you when you characterize a calculation just work when they are connected to specific data types.



 A sequences zero or more characters. For instance, and “Tom Sawyer”, “ID-44400”, “Wisconsin “are strings. Strings are recognized by single or double quotes. The quote character itself can be incorporated into a string by repeating it. For example, ‘ONLINE’ITGURU’.

Date /DateTime :

  A date or a datetime. For example “January 23 or “January 23, 1972” 1972 12:32:00 AM”. IF you might want a date written in long-hand style to be interpreted as a date/date time, put the # sign on either side of it. For example, “January 23, 1972” is dealt with as a string data type however #January 23, 1972# is treated as a date/datetime data type.


 In Tableau, Numerical values can be either integers or floating point numbers.When we use  floating point numbers, results  of a few accumulations may not  be same  as expected  For example  you may find that the SUM function that  returns  an value , for example, – 1.42e-14 for a column  of numbers that  should aggregate to exactly 0. This happens in light of the fact that the Institute of Electrical and Electronics Engineers (IEEE) 754 floating point standard requires that numbers be stored  in binary format , which implies that numbers are some of the time adjusted at to a great degree fine levels of precision. You can eliminate this potential distraction by utilizing the ROUND function (see Number Functions or by designing the number to indicate less decimal spots.


A field that contains TRUE or FALSE. An unknown value emerges when the result of an examination is obscure. For instance, the articulation 7 > Null yields unknown. Unknown Boolean are naturally changed over to Null.

Drop Us A Query

Trending Courses
  • Python and Django Online Training
  • Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.

  • Tableau Online Training
  • Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.

  • MicroStrategy Online Training
  • We people have been hearing the word Microstrategy over the past few years. But what is this Microstrategy? Why it’s needed? What is its advantage? Do you have all these questions

  • PEGA (PRPC) 7.3 Certification Online Training
  • Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).

  • Workday Online Training
  • Workday specialises in providing Human Capital Management, Financial Management and payroll in online domain.It is a major web based ERP software vendor.

  • Power BI Online Training
  • the need for analyzing the data is an important play major role. Because we are living in a place where we cannot find an application without big data.

100% Secure Payments. All major credit & debit cards accepted.