Tableau Desktop 2

Tableau Desktop is a data visualization tool that helps us get actionable insights about data fast. It differs from Tableau Server in that it provides users with the ability to develop comprehensive, interactive workbooks and dashboards to fulfill their academic or business requirements.

Tableau Desktop 2: Intermediate course is designed to expand your skills and distinguish yourself as a Tableau power user. It's structured for those who have a working experience with Tableau and want to take it to the next level. However, things have changed now that Tableau has introduced the new data model/relationships in 2020.2 (Note: If you’re not yet familiar with the new data model, I’d suggest reading my blog on the topic, Tableau's New Data Model, before you proceed). This new functionality opens some doors that will allow us to perform multiple pivots.

  • For Excel and text file data sources, this option is available only in workbooks that were created before Tableau Desktop 8.2 or when using Tableau Desktop on Windows with the legacy connection. To connect to Excel or text files using the legacy connection, connect to the file, and in the Open dialog box, click the Open drop-down menu, and then.
  • Support me on Patreontableau desktop software full version with crackLink To Download Tableau Desktop Profess.

What is Tableau Desktop?

Tableau Desktop is our primary tool for creating data visualizations. To learn more about Tableau Desktop and the way it works, we recommend watching the brief video below, provided by Tableau Software.

Which version of Tableau Desktop should I be using?

At this time, all Tableau Desktop users should be using version 2020.3.4 or older (e.g., 2018.1.2, 10.4.1, 9.3.9, etc.). Tableau has recently changed its versioning to be identified by year and will continue to produce updates with this syntax.

Where can I download Tableau Desktop?

Before downloading Tableau Desktop, please make sure that your computer meets the following recommended requirements. If you need assistance with verifying the requirements of your computer, please contact your respective IT support staff.
2019.1

Windows

  • Microsoft Windows 7 or newer (64-bit)
  • 2 GB memory
  • 1.5 GB minimum free disk space
  • 64-bit Intel or AMD processors released in 2011 or later (CPUs must support SSE4.2 and POPCNT instruction sets)
  • 1366 by 768 screen resolution or higher

Mac

  • macOS High Sierra 10.13, macOS Mojave 10.14, or macOS Catalina 10.15
  • 64-bit Intel processors released in 2011 or later (CPUs must support SSE4.2 and POPCNT instruction sets; M1 processors are not yet supported)
  • 1.5 GB minimum free disk space
  • 1366 by 768 screen resolution or higher
We recommend downloading Tableau Desktop from https://www.tableau.com/support/releases. In the Product Downloads section, click to download the appropriate Tableau Desktop installer version (i.e., Windows 64-bit or Mac). Starting with version 10.5, Tableau Desktop will no longer be supported on Windows 32-bit operating systems. To determine which version of Windows you're using (i.e., 32-bit or 64-bit), please refer to this article, provided by Microsoft.

If you do not have a Tableau Desktop license, you will be able to use the software during a free 14-day trial before you will be required to enter a product key to continue using the application.

How do I install Tableau Desktop?

Installing Tableau Desktop is easy. Just open the installer that was downloaded from Tableau's Alternate Downloads Site, and follow the steps provided. If you have already purchased a Tableau Desktop license, you will be asked to enter it and activate your software at the time of installation. If you need to access data managed by SAP HANA, please refer to our SAP HANA resources page.
Tableau Desktop 2

How can I purchase a license?

With a license for Tableau Desktop, you will be able to connect to 40+ data sources, including Microsoft Excel files, and the University's central database management system, SAP HANA. Additionally, you will receive a year of updates and support provided by Tableau. Per Tableau's End User License Agreement (EULA), each license can be used on up to two different machines.

For more information about purchasing a Tableau Desktop license, please contact [email protected]

How do I connect to SAP HANA with Tableau Desktop?

If already have access to SAP HANA, follow the applicable steps for your operating system:

For more information about SAP HANA, check out our SAP HANA resources page.

I'm having trouble with Tableau Desktop. Help!

Sometimes you may receive an error or experience issues when connecting to SAP HANA through Tableau Desktop. In these instances, we recommend that you check out our troubleshooting page.

If, after troubleshooting, you continue having problems with Tableau Desktop, please contact us.

What training resources do I have access to?

Tableau offers many free online resources as well as specialized resources. This includes:

In addition, we recommend that you check out the following resources to help you along the way:

I still have questions. Who can I contact?

Tableau

For questions, or to get more information about Tableau Desktop, please contact us.

This article introduces string functions and their uses in Tableau. It also demonstrates how to create a string calculation using an example.

Why use string functions

String functions allow you to manipulate string data (i.e. data made of text).

For example, you might have a field that contains all of your customers' first and last names. One member might be: Jane Johnson. You can pull the last names from all your customers into a new field using a string function.

The calculation might look something like this:

SPLIT([Customer Name], ' ', 2)

Therefore, SPLIT('Jane Johnson' , ' ', 2) = 'Johnson'.

String functions available in Tableau:

Function

Syntax

Definition

ASCII

ASCII(string)

Returns the ASCII code for the first character of string.

Example:

ASCII('A') = 65

CHAR

CHAR(number)

Returns the character encoded by the ASCII code number.

Example:

CHAR(65) = 'A'

CONTAINS

CONTAINS(string, substring)

Returns true if the given string contains the specified substring.

Example:

CONTAINS(“Calculation”, “alcu”) = true

ENDSWITH

ENDSWITH(string, substring)

Returns true if the given string ends with the specified substring. Trailing white spaces are ignored.

Example:

ENDSWITH(“Tableau”, “leau”) = true

FIND

FIND(string, substring, [start])

Returns the index position of substring in string, or 0 if the substring isn't found. If the optional argument start is added, the function ignores any instances of substring that appear before the index position start. The first character in the string is position 1.

Examples:

FIND('Calculation', 'alcu') = 2
FIND('Calculation', 'Computer') = 0
FIND('Calculation', 'a', 3) = 7
FIND('Calculation', 'a', 2) = 2
FIND('Calculation', 'a', 8) = 0
FIND('Calculation', 'a', 3) = 7
FIND('Calculation', 'a', 2) = 2
FIND('Calculation', 'a', 8) = 0

FINDNTH

FINDNTH(string, substring, occurrence)

Returns the position of the nth occurrence of substring within the specified string, where n is defined by the occurrence argument.

Note: FINDNTH is not available for all data sources.

Example:

FINDNTH('Calculation', 'a', 2) = 7

LEFT

LEFT(string, number)

Returns the left-most number of characters in the string.

Example:

LEFT('Matador', 4) = 'Mata'

LEN

LEN(string)

Returns the length of the string.

Example:

LEN('Matador') = 7

LOWER

LOWER(string)

Returns string, with all characters lowercase.

Example:

LOWER('ProductVersion') = 'productversion'

LTRIM

LTRIM(string)

Returns the string with any leading spaces removed.

Example:

LTRIM(' Matador ') = 'Matador '

MAX

MAX(a, b)

Returns the maximum of a and b (which must be of the same type). This function is usually used to compare numbers, but also works on strings. With strings, MAX finds the value that is highest in the sort sequence defined by the database for that column. It returns Null if either argument is Null.

Example:

MAX ('Apple','Banana') = 'Banana'

MID

(MID(string, start, [length])

Returns the string starting at index position start. The first character in the string is position 1. If the optional argument length is added, the returned string includes only that number of characters.

Examples:

MID('Calculation', 2) = 'alculation'
MID('Calculation', 2, 5) ='alcul'

MIN

MIN(a, b)

Returns the minimum of a and b (which must be of the same type). This function is usually used to compare numbers, but also works on strings. With strings, MIN finds the value that is lowest in the sort sequence. It returns Null if either argument is Null.

Example:

MIN ('Apple','Banana') = 'Apple'

REPLACE

REPLACE(string, substring, replacement)

Searches string for substring and replaces it with replacement. If substring is not found, the string is not changed.

Example:

REPLACE('Version8.5', '8.5', '9.0') = 'Version9.0'

RIGHT

RIGHT(string, number)

Returns the right-most number of characters in string.

Example:

RIGHT('Calculation', 4) = 'tion'

RTRIM

RTRIM(string)

Returns string with any trailing spaces removed.

Example:

RTRIM(' Calculation ') = ' Calculation'

SPACE

SPACE(number)

Returns a string that is composed of the specified number of repeated spaces.

Example:

SPACE(1) = ' '

SPLIT

SPLIT(string, delimiter, token number)

Returns a substring from a string, using a delimiter character to divide the string into a sequence of tokens.

The string is interpreted as an alternating sequence of delimiters and tokens. So for the string abc-defgh-i-jkl, where the delimiter character is ‘-‘, the tokens are abc, defgh, i, and jlk. Think of these as tokens 1 through 4. SPLIT returns the token corresponding to the token number. When the token number is positive, tokens are counted starting from the left end of the string; when the token number is negative, tokens are counted starting from the right.

Examples:

SPLIT (‘a-b-c-d’, ‘-‘, 2) = ‘b’
SPLIT (‘a b c d’, ‘ ‘, -2) = ‘c’


Note: The split and custom split commands are available for the following data sources types: Tableau data extracts, Microsoft Excel, Text File, PDF File, Salesforce, OData, Microsoft Azure Market Place, Google Analytics, Vertica, Oracle, MySQL, PostgreSQL, Teradata, Amazon Redshift, Aster Data, Google Big Query, Cloudera Hadoop Hive, Hortonworks Hive, and Microsoft SQL Server.

Some data sources impose limits on splitting string. The following table shows which data sources support negative token numbers (splitting from the right) and whether there is a limit on the number of splits allow per data source. A SPLIT function that specifies a negative token number and would be legal with other data sources will return this error with these data sources: “Splitting from right is not support by the data source.”

Data SourceLeft/Right ConstraintsMaximum Number of SplitsVersion limitations
Tableau Data ExtractBothInfinite
Microsoft ExcelBothInfinite
Text fileBothInfinite
SalesforceBothInfinite
ODataBothInfinite
Google AnalyticsBothInfinite
Tableau Data ServerBothInfiniteSupported in version 9.0.
VerticaLeft only10
OracleLeft only10
MySQLBoth10
PostgreSQLLeft only prior to version 9.0; both for version 9.0 and above10
TeradataLeft only10Version 14 and later
Amazon RedshiftLeft only10
Aster DatabaseLeft only10
Google BigQueryLeft only10
Hortonworks Hadoop HiveLeft only10
Cloudera HadoopLeft only10Impala supported starting in version 2.3.0.
Microsoft SQL ServerBoth102008 and later

STARTSWITH

STARTSWITH(string, substring)

Returns true if string starts with substring. Leading white spaces are ignored.

Example:

STARTSWITH(“Joker”, “Jo”) = true

TRIM

TRIM(string)

Returns the string with leading and trailing spaces removed.

Example:

TRIM(' Calculation ') = 'Calculation'

UPPER

UPPER(string)

Returns string, with all characters uppercase.

Example:

UPPER('Calculation') = 'CALCULATION'


Tableau Desktop 2019.1

Create a string calculation

Follow along with the steps below to learn how to create a string calculation.

Tableau Desktop 2020.2.5

  1. In Tableau Desktop, connect to the Sample - Superstore saved data source, which comes with Tableau.

  2. Navigate to a worksheet.

  3. From the Data pane, under Dimensions, drag Order ID to the Rows shelf.

    Notice that every order ID contains values for country (CA and US, for example), year (2011), and order number (100006). For this example, you will create a calculation to pull only the order number from the field.

  4. Select Analysis > Create Calculated Field.

  5. In the calculation editor that opens, do the following:

    • Name the calculated field Order ID Numbers.

    • Enter the following formula:

      RIGHT([Order ID], 6)

      This formula takes the specified digits (6) from the right of the string and pulls them into a new field.

      Therefore, RIGHT('CA-2011-100006' , 6) = '100006'.

    • When finished, click OK.

      The new calculated field appears under Dimensions in the Data pane. Just like your other fields, you can use it in one or more visualizations.

  6. From the Data pane, drag Order ID Numbers to the Rows shelf. Place it to the right of Order ID.

    Notice how the fields differ now.

Tableau desktop 2018.2 download

Tableau Desktop 2019.4

See Also

Tableau Desktop 2020.4.1

Thanks for your feedback!