Tableau eLearning is web-based training you can consume at your own pace. Courses are interactive and designed to help you learn Tableau, regardless of skill level. Once verified through our Tableau for Students program, you will receive a code and instructions on how to register at the Tableau. Aug 14, 2020 Can be saved as a local file and can be published in Tableau Server and Tableau Online: Can be published only in Tableau Public profile: OS: Windows and Mac: Windows and Mac: Security: Data and Visualizations are secured: Data and visualizations are not secured as it is available in public: Usage Details: Professional and Enterprise level. May 01, 2018 Operating Systems Windows Windows 7 or newer (64-bit) 2 GB memory 1.5 GB minimum free disk space Mac iMac/MacBook computers 2009 or newer macOS High Sierra 10.13 and macOS Mojave 10.14 1.5 GB minimum free disk space. Aug 17, 2020 Tableau Desktop 2020.4.3 Crack Free Download For Mac & Windows 2020 Tableau Crack is known most efficient tool for the analysis of information. Mostly this tool used for the creation of reports, graphs, and much more related to workflow enhancement.
This article introduces table calculation functions and their uses in Tableau. It also demonstrates how to create a table calculation using the calculation editor.
Why use table calculation functions
Table calculation functions allow you to perform computations on values in a table.
For example, you can calculate the percent of total an individual sale is for the year, or for several years.
Table calculation functions available in Tableau
FIRST( )
Returns the number of rows from the current row to the first row in the partition. For example, the view below shows quarterly sales. When FIRST() is computed within the Date partition, the offset of the first row from the second row is -1.
Example
When the current row index is 3,
FIRST() = -2
.INDEX( )
Returns the index of the current row in the partition, without any sorting with regard to value. The first row index starts at 1. For example, the table below shows quarterly sales. When INDEX() is computed within the Date partition, the index of each row is 1, 2, 3, 4.., etc.
Example
Tableau Macro
For the third row in the partition,
INDEX() = 3
.LAST( )
Returns the number of rows from the current row to the last row in the partition. For example, the table below shows quarterly sales. When LAST() is computed within the Date partition, the offset of the last row from the second row is 5.
Example
When the current row index is 3 of 7,
LAST() = 4
.LOOKUP(expression, [offset])
Returns the value of the expression in a target row, specified as a relative offset from the current row. Use FIRST() + n and LAST() - n as part of your offset definition for a target relative to the first/last rows in the partition. If
offset
is omitted, the row to compare to can be set on the field menu. This function returns NULL if the target row cannot be determined.The view below shows quarterly sales. When
LOOKUP (SUM(Sales), 2)
is computed within the Date partition, each row shows the sales value from 2 quarters into the future.Example
LOOKUP(SUM([Profit]), FIRST()+2)
computes the SUM(Profit) in the third row of the partition.MODEL_PERCENTILE(target_expression, predictor_expression(s))
Returns the probability (between 0 and 1) of the expected value being less than or equal to the observed mark, defined by the target expression and other predictors. This is the Posterior Predictive Distribution Function, also known as the Cumulative Distribution Function (CDF).
This function is the inverse of MODEL_QUANTILE. For information on predictive modeling functions, see How Predictive Modeling Functions Work in Tableau.
Example
The following formula returns the quantile of the mark for sum of sales, adjusted for count of orders.
MODEL_PERCENTILE(SUM([Sales]), COUNT([Orders]))
MODEL_QUANTILE(quantile, target_expression, predictor_expression(s))
Returns a target numeric value within the probable range defined by the target expression and other predictors, at a specified quantile. This is the Posterior Predictive Quantile.
This function is the inverse of MODEL_PERCENTILE. For information on predictive modeling functions, see How Predictive Modeling Functions Work in Tableau.
Example
The following formula returns the median (0.5) predicted sum of sales, adjusted for count of orders.
MODEL_QUANTILE(0.5, SUM([Sales]), COUNT([Orders]))
PREVIOUS_VALUE(expression)
Returns the value of this calculation in the previous row. Returns the given expression if the current row is the first row of the partition.
Example
SUM([Profit]) * PREVIOUS_VALUE(1)
computes the running product of SUM(Profit).RANK(expression, ['asc' | 'desc'])
Returns the standard competition rank for the current row in the partition. Identical values are assigned an identical rank. Use the optional
'asc' | 'desc'
argument to specify ascending or descending order. The default is descending.With this function, the set of values (6, 9, 9, 14) would be ranked (4, 2, 2, 1).
Nulls are ignored in ranking functions. They are not numbered and they do not count against the total number of records in percentile rank calculations.
For information on different ranking options, see Rank calculation.
Example
The following image shows the effect of the various ranking functions (RANK, RANK_DENSE, RANK_MODIFIED, RANK_PERCENTILE, and RANK_UNIQUE) on a set of values. The data set contains information on 14 students (StudentA through StudentN); the Age column shows the current age of each student (all students are between 17 and 20 years of age). The remaining columns show the effect of each rank function on the set of age values, always assuming the default order (ascending or descending) for the function.
RANK_DENSE(expression, ['asc' | 'desc'])
Returns the dense rank for the current row in the partition. Identical values are assigned an identical rank, but no gaps are inserted into the number sequence. Use the optional
'asc' | 'desc'
argument to specify ascending or descending order. The default is descending.With this function, the set of values (6, 9, 9, 14) would be ranked (3, 2, 2, 1).
Nulls are ignored in ranking functions. They are not numbered and they do not count against the total number of records in percentile rank calculations.
For information on different ranking options, see Rank calculation.
RANK_MODIFIED(expression, ['asc' | 'desc'])
Returns the modified competition rank for the current row in the partition. Identical values are assigned an identical rank. Use the optional
'asc' | 'desc'
argument to specify ascending or descending order. The default is descending.With this function, the set of values (6, 9, 9, 14) would be ranked (4, 3, 3, 1).
Nulls are ignored in ranking functions. They are not numbered and they do not count against the total number of records in percentile rank calculations.
For information on different ranking options, see Rank calculation.
RANK_PERCENTILE(expression, ['asc' | 'desc'])
Returns the percentile rank for the current row in the partition. Use the optional
'asc' | 'desc'
argument to specify ascending or descending order. The default is ascending.With this function, the set of values (6, 9, 9, 14) would be ranked (0.00, 0.67, 0.67, 1.00).
Nulls are ignored in ranking functions. They are not numbered and they do not count against the total number of records in percentile rank calculations.
For information on different ranking options, see Rank calculation.
RANK_UNIQUE(expression, ['asc' | 'desc'])
Returns the unique rank for the current row in the partition. Identical values are assigned different ranks. Use the optional
'asc' | 'desc'
argument to specify ascending or descending order. The default is descending.With this function, the set of values (6, 9, 9, 14) would be ranked (4, 2, 3, 1).
Nulls are ignored in ranking functions. They are not numbered and they do not count against the total number of records in percentile rank calculations.
For information on different ranking options, see Rank calculation.
Download Tableau Creator
RUNNING_AVG(expression)
Returns the running average of the given expression, from the first row in the partition to the current row.
The view below shows quarterly sales. When
RUNNING_AVG(SUM([Sales])
is computed within the Date partition, the result is a running average of the sales values for each quarter.Example
RUNNING_AVG(SUM([Profit]))
computes the running average of SUM(Profit).RUNNING_COUNT(expression)
Returns the running count of the given expression, from the first row in the partition to the current row.
Example
RUNNING_COUNT(SUM([Profit]))
computes the running count of SUM(Profit).Coats 1004 wheel balancer manual. Browse industry leading tire changer, brake lathe, and wheel balancing machines from the world's foremost wheel-service manufacturers, Hennessy Industries. GTM-KMN7V56 coatsdefault Coats. View & download of more than 27 Coats PDF user manuals, service manuals, operating guides. Tyre Changers, Wheel Balancers user manuals, operating guides & specifications. Manual Part No.: 85009054 01. HENNESSY INDUSTRIES INC. Manufacturer of AMMCO ®, COATS ® and BADA ® Automotive Service Equipment and Tools. Revision: 03/08. WHEEL BALANCER. Installation Instructions. Operating Instructions. 1004 Coates Tire Balancer Repair Manual pontiac haynes coats tire changer parts, repair, coats tire machine parts 2005 yz125 repair manual coats/model 1000 wheel balancer amm85009045 at. Search: Search. Service Locator; Work For Us. Tire Changers. 50X-1 Rim Clamp® Tire Changer. 60X-1 Rim Clamp® Tire Changer. 70X-1 Rim Clamp® Tire Changer. Wheel Balancers. 775 Wheel Balancer. 875 Wheel Balancer (40mm) 1000 Wheel Balancer. 1000D Wheel Balancer. 1100 Wheel Balancer.
RUNNING_MAX(expression)
Returns the running maximum of the given expression, from the first row in the partition to the current row.
![Tableau Mac Tableau Mac](https://www.macsoftdownload.com/wp-content/uploads/2017/03/Tableau-Desktop-mac.jpg)
Example
RUNNING_MAX(SUM([Profit]))
computes the running maximum of SUM(Profit).RUNNING_MIN(expression)
Returns the running minimum of the given expression, from the first row in the partition to the current row.
Example
RUNNING_MIN(SUM([Profit]))
computes the running minimum of SUM(Profit).RUNNING_SUM(expression)
Returns the running sum of the given expression, from the first row in the partition to the current row.
Example
RUNNING_SUM(SUM([Profit]))
computes the running sum of SUM(Profit)SIZE()
Returns the number of rows in the partition. For example, the view below shows quarterly sales. Within the Date partition, there are seven rows so the Size() of the Date partition is 7.
Example
SIZE() = 5
when the current partition contains five rows.SCRIPT_BOOL
Returns a Boolean result from the specified expression. The expression is passed directly to a running analytics extension service instance.
In R expressions, use .argn (with a leading period) to reference parameters (.arg1, .arg2, etc.).
In Python expressions, use _argn (with a leading underscore).
Examples
In this R example, .arg1 is equal to SUM([Profit]):
SCRIPT_BOOL('is.finite(.arg1)', SUM([Profit]))
The next example returns True for store IDs in Washington state, and False otherwise. This example could be the definition for a calculated field titled IsStoreInWA.
SCRIPT_BOOL('grepl('.*_WA', .arg1, perl=TRUE)',ATTR([Store ID]))
A command for Python would take this form:
SCRIPT_BOOL('return map(lambda x : x > 0, _arg1)', SUM([Profit]))
SCRIPT_INT
Returns an integer result from the specified expression. The expression is passed directly to a running analytics extension service instance.
In R expressions, use .argn (with a leading period) to reference parameters (.arg1, .arg2, etc.)
In Python expressions, use _argn (with a leading underscore).
Examples
In this R example, .arg1 is equal to SUM([Profit]):
SCRIPT_INT('is.finite(.arg1)', SUM([Profit]))
In the next example, k-means clustering is used to create three clusters:
SCRIPT_INT('result <- kmeans(data.frame(.arg1,.arg2,.arg3,.arg4), 3);result$cluster;', SUM([Petal length]), SUM([Petal width]),SUM([Sepal length]),SUM([Sepal width]))
A command for Python would take this form:
SCRIPT_INT('return map(lambda x : int(x * 5), _arg1)', SUM([Profit]))
SCRIPT_REAL
Returns a real result from the specified expression. The expression is passed directly to a running analytics extension service instance. In
R expressions, use .argn (with a leading period) to reference parameters (.arg1, .arg2, etc.)
In Python expressions, use _argn (with a leading underscore).
Examples
In this R example, .arg1 is equal to SUM([Profit]):
SCRIPT_REAL('is.finite(.arg1)', SUM([Profit]))
The next example converts temperature values from Celsius to Fahrenheit.
SCRIPT_REAL('library(udunits2);ud.convert(.arg1, 'celsius', 'degree_fahrenheit')',AVG([Temperature]))
A command for Python would take this form:
SCRIPT_REAL('return map(lambda x : x * 0.5, _arg1)', SUM([Profit]))
SCRIPT_STR
Returns a string result from the specified expression. The expression is passed directly to a running analytics extension service instance.
In R expressions, use .argn (with a leading period) to reference parameters (.arg1, .arg2, etc.)
In Python expressions, use _argn (with a leading underscore).
Examples
In this R example, .arg1 is equal to SUM([Profit]):
SCRIPT_STR('is.finite(.arg1)', SUM([Profit]))
The next example extracts a state abbreviation from a more complicated string (in the original form 13XSL_CA, A13_WA):
SCRIPT_STR('gsub('.*_', ', .arg1)',ATTR([Store ID]))
A command for Python would take this form:
SCRIPT_STR('return map(lambda x : x[:2], _arg1)', ATTR([Region]))
TOTAL(expression)
Returns the total for the given expression in a table calculation partition.
Example
Assume you are starting with this view:
You open the calculation editor and create a new field which you name Totality:
You then drop Totality on Text, to replace SUM(Sales). Your view changes such that it sums values based on the default Compute Using value:
This raises the question, What is the default Compute Using value? If you right-click (Control-click on a Mac) Totality in the Data pane and choose Edit, there is now an additional bit of information available:
The default Compute Using value is Table (Across). The result is that Totality is summing the values across each row of your table. Thus, the value that you see across each row is the sum of the values from the original version of the table.
The values in the 2011/Q1 row in the original table were $8601, $6579, $44262, and $15006. The values in the table after Totality replaces SUM(Sales) are all $74,448, which is the sum of the four original values.
Notice the triangle next to Totality after you drop it on Text:
This indicates that this field is using a table calculation. You can right-click the field and choose Edit Table Calculation to redirect your function to a different Compute Using value. For example, you could set it to Table (Down). In that case, your table would look like this:
WINDOW_AVG(expression, [start, end])
Returns the average of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
For example, the view below shows quarterly sales. A window average within the Date partition returns the average sales across all dates.
Example
WINDOW_AVG(SUM([Profit]), FIRST()+1, 0)
computes the average of SUM(Profit) from the second row to the current row.WINDOW_CORR(expression1, expression2, [start, end])
Returns the Pearson correlation coefficient of two expressions within the window. The window is defined as offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If start and end are omitted, the entire partition is used.
The Pearson correlation measures the linear relationship between two variables. Results range from -1 to +1 inclusive, where 1 denotes an exact positive linear relationship, as when a positive change in one variable implies a positive change of corresponding magnitude in the other, 0 denotes no linear relationship between the variance, and −1 is an exact negative relationship.
There is an equivalent aggregation fuction: CORR. See Tableau Functions (Alphabetical)(Link opens in a new window).
Example
The following formula returns the Pearson correlation of SUM(Profit) and SUM(Sales) from the five previous rows to the current row.
WINDOW_CORR(SUM[Profit]), SUM([Sales]), -5, 0)
WINDOW_COUNT(expression, [start, end])
Returns the count of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_COUNT(SUM([Profit]), FIRST()+1, 0)
computes the count of SUM(Profit) from the second row to the current rowWINDOW_COVAR(expression1, expression2, [start, end])
Returns the sample covariance of two expressions within the window. The window is defined as offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end arguments are omitted, the window is the entire partition.
Sample covariance uses the number of non-null data points n - 1 to normalize the covariance calculation, rather than n, which is used by the population covariance (with the WINDOW_COVARP function). Sample covariance is the appropriate choice when the data is a random sample that is being used to estimate the covariance for a larger population.
There is an equivalent aggregation fuction: COVAR. See Tableau Functions (Alphabetical)(Link opens in a new window).
Example
The following formula returns the sample covariance of SUM(Profit) and SUM(Sales) from the two previous rows to the current row.
WINDOW_COVAR(SUM([Profit]), SUM([Sales]), -2, 0)
WINDOW_COVARP(expression1, expression2, [start, end])
Returns the population covariance of two expressions within the window. The window is defined as offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If start and end are omitted, the entire partition is used.
Population covariance is sample covariance multiplied by (n-1)/n, where n is the total number of non-null data points. Population covariance is the appropriate choice when there is data available for all items of interest as opposed to when there is only a random subset of items, in which case sample covariance (with the WINDOW_COVAR function) is appropriate.
There is an equivalent aggregation fuction: COVARP. Tableau Functions (Alphabetical)(Link opens in a new window).
Example
The following formula returns the population covariance of SUM(Profit) and SUM(Sales) from the two previous rows to the current row.
WINDOW_COVARP(SUM([Profit]), SUM([Sales]), -2, 0)
WINDOW_MEDIAN(expression, [start, end])
Returns the median of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
For example, the view below shows quarterly profit. A window median within the Date partition returns the median profit across all dates.
Example
WINDOW_MEDIAN(SUM([Profit]), FIRST()+1, 0)
computes the median of SUM(Profit) from the second row to the current row.WINDOW_MAX(expression, [start, end])
Returns the maximum of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
For example, the view below shows quarterly sales. A window maximum within the Date partition returns the maximum sales across all dates.
Example
WINDOW_MAX(SUM([Profit]), FIRST()+1, 0)
computes the maximum of SUM(Profit) from the second row to the current row.WINDOW_MIN(expression, [start, end])
Returns the minimum of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
For example, the view below shows quarterly sales. A window minimum within the Date partition returns the minimum sales across all dates.
Example
WINDOW_MIN(SUM([Profit]), FIRST()+1, 0)
computes the minimum of SUM(Profit) from the second row to the current row.WINDOW_PERCENTILE(expression, number, [start, end])
Returns the value corresponding to the specified percentile within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_PERCENTILE(SUM([Profit]), 0.75, -2, 0)
returns the 75th percentile for SUM(Profit) from the two previous rows to the current row.WINDOW_STDEV(expression, [start, end])
Returns the sample standard deviation of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_STDEV(SUM([Profit]), FIRST()+1, 0)
computes the standard deviation of SUM(Profit) from the second row to the current row.WINDOW_STDEVP(expression, [start, end])
Returns the biased standard deviation of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_STDEVP(SUM([Profit]), FIRST()+1, 0)
computes the standard deviation of SUM(Profit) from the second row to the current row.WINDOW_SUM(expression, [start, end])
Returns the sum of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
For example, the view below shows quarterly sales. A window sum computed within the Date partition returns the summation of sales across all quarters.
Example
WINDOW_SUM(SUM([Profit]), FIRST()+1, 0)
computes the sum of SUM(Profit) from the second row to the current row.WINDOW_VAR(expression, [start, end])
Returns the sample variance of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_VAR((SUM([Profit])), FIRST()+1, 0)
computes the variance of SUM(Profit) from the second row to the current row.WINDOW_VARP(expression, [start, end])
Returns the biased variance of the expression within the window. The window is defined by means of offsets from the current row. Use FIRST()+n and LAST()-n for offsets from the first or last row in the partition. If the start and end are omitted, the entire partition is used.
Example
WINDOW_VARP(SUM([Profit]), FIRST()+1, 0)
computes the variance of SUM(Profit) from the second row to the current row.Create a table calculation using the calculation editor
Follow along with the steps below to learn how to create a table calculation using the calculation editor.
Note: There are several ways to create table calculations in Tableau. This example demonstrates only one of those ways. For more information, see Transform Values with Table Calculations(Link opens in a new window).
Step 1: Create the visualization
- In Tableau Desktop, connect to the Sample-Superstore saved data source, which comes with Tableau.
- Navigate to a worksheet.
- From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
- From the Data pane, under Dimensions, drag Sub-Category to the Rows shelf.
- From the Data pane, under Measures, drag Sales to Text on the Marks card.Your visualization updates to a text table.
Step 2: Create the table calculation
- Select Analysis > Create Calculated Field.
- In the calculation editor that opens, do the following:
- Name the calculated field, Running Sum of Profit.
- Enter the following formula:Jun 23, 2012 Somebody already mentioned it in the second post, best solution would be to copy the game to the hdd and use an iso forwarder channel (wad file), and one program who can do it is 'crap'. But there are more programs which can create iso forwarder channels. Convert wad to iso file.
RUNNING_SUM(SUM([Profit]))
This formula calculates the running sum of profit sales. It is computed across the entire table. - When finished, click OK.The new table calculation field appears under Measures in the Data pane. Just like your other fields, you can use it in one or more visualizations.
Step 3: Use the table calculation in the visualization
- From the Data pane, under Measures, drag Running Sum of Profit to Color on the Marks card.
- On the Marks card, click the Mark Type drop-down and select Square.The visualization updates to a highlight table:
Step 4: Edit the table calculation
- On the Marks card, right-click Running Sum of Profit and select Edit Table Calculation.
- In the Table Calculation dialog box that opens, under Compute Using, select Table (down).The visualization updates to the following:
See Also
Note: If you are looking for information about how to install Tableau Server, see the Install and Configure(Link opens in a new window) section in the Tableau Server Help instead.
This topic describes how to install and activate Tableau Desktop or Tableau Prep Builder from the user interface. For information about how to install and activate your product from the command line, see Install Tableau Desktop and Tableau Prep Builder from the Command Line(Link opens in a new window).
Before you begin
To install Tableau Desktop or Tableau Prep Builder you will need two things; a Creator product key (the key number starts with the letters TC) and the installer for the version you want to install. For information about what applications are included with a Creator product key, see the Tableau Pricing(Link opens in a new window) page.
Where's the installer?
Important: Starting with version 10.5, Tableau Desktop, Tableau Reader, and Tableau Public (desktop) only run on a 64-bit operating system. Tableau Prep Builder is only available for a 64-bit operating system. If you want to install Tableau Desktop on a 32-bit operating system, open the Product Downloads and Release Notes(Link opens in a new window) page and download the installer for version 10.4 or earlier and follow the install instructions in the Tableau Desktop Deployment(Link opens in a new window) guide for that version.
For the most current version of Tableau Desktop or Tableau Prep Builder, go to the Customer Portal(Link opens in a new window) page. In the Product Downloads section, click the appropriate link to download the installer for your product and operating system.
You can also find the installers for all products and versions on the Product Downloads and Release Notes(Link opens in a new window) page.
- Open the Product Downloads and Release Notes(Link opens in a new window) page and select Tableau Desktop or Tableau Prep Builder from the list on the left side of the page.
- Click on the version you want to install.
- In the Download Files section of the page, click on the installer for your operating system to download it.
Where's my product key?
You need your product key to activate Tableau Desktop and Tableau Prep Builder after the install process is finished. If you have a creator license, the same key activates both Tableau Desktop and Tableau Prep Builder. You can always view your product key in the Customer Portal(Link opens in a new window). For more information about license types, see User-Based licenses(Link opens in a new window) in the Tableau Server help.
Note: If you have trouble signing in to the Customer Portal page, or if you need help retrieving your product key, contact Customer Service(Link opens in a new window) and provide your name, company, phone number, and email address.
As a first time user
- Sign in to the Customer Portal(Link opens in a new window) page on the Tableau website using your email address and password. The information you need to sign into the portal for the first time is sent to you in a welcome email from Tableau after you purchase(Link opens in a new window) the product.
- At the top of the Tableau Customer Portal page, click My Keys.
- A table opens, listing any product keys assigned to you. Copy your product key from the Key Name column in the table. Keep this key ready and secure.Note: This example does not show any actual keys. The highlighted area shows where your key would be listed.
As an existing user
- Open your existing version of Tableau Desktop or Tableau Prep Builder.
- From the top menu, click Help > Manage Product Keys.
- Copy your product key from the Product Key column in the table. Keep this key ready and secure.If you are not able to open the Manage Product Keys dialog to see your key, log into the Customer Portal(Link opens in a new window) and follow the instructions for first time users above.
If you don't have a product key, try the 14-day Free Trial(Link opens in a new window) or download the Tableau Desktop Public Edition(Link opens in a new window) instead. If you are a student or teacher, go to the Academic programs(Link opens in a new window) page to request a license and receive instructions about how to download your copy of Tableau Desktop or Tableau Prep Builder.
Install the product
Download the installer using the instructions in Where's the installer? For Mac, the installer is downloaded to your Downloads folder.
Note: The installer detects and displays the user interface based on the operating system display language setting.
If you're using a deployment tool that requires the Windows installer (
.msi
file) to install Tableau Desktop or Tableau Prep Builder, follow the instructions in Extract and run the Windows (MSI) installer to extract the .msi
file from the Tableau installer .exe
file.Click the tab for the product you are installing to view the installation steps. Visual micro keygens.
- As an Administrator, log in to the computer where you are installing Tableau Desktop.
- Depending on your operating system, do one of the following:
- For Windows: Run the installer and follow the prompts.
- For Mac: Open the Disk image file (.DMG) and double-click the installer package (.PKG) to start the installation.
Drivers for some data sources are installed automatically when you install Tableau Desktop. See the Database drivers installed with Tableau Desktop and Tableau Prep Builder section in the Before You Install topic for specifics. - To enable or disable usage reporting complete the following steps for your operating system.This option allows us to gather usage pattern data to improve the product. For more information about this option and how to turn it off after installation, see Turn off usage reporting.Windows
- To opt out of providing usage data, select the Don't send product usage data check box.
Mac- On the Installation Type step, in the bottom-left of the install wizard, click Customize. To opt out of sending product usage data, select the Don't send product usage data check box.On the Mac you can also change the settings on this page to customize your install.Note: Starting in Tableau Desktop version 2019.4, only the PostgreSQL driver is installed automatically on the Mac. If you need other database drivers, you can install them from the Driver Download(Link opens in a new window) page.
- (Optional) On Windows, to customize the install, on the Install welcome screen, click Customize and change any of the following options:
- Install location: Specify a different location to install Tableau Desktop.Important: If you specify a custom directory for the install location and plan to install future releases to this same location, you need to specify a version specific sub-folder to install to. Otherwise you will need to uninstall the previous version first. Side-by-side installs of multiple versions in the same sub-directory is not supported.
- Create a desktop shortcut: Clear the check box if you don't want to automatically create a desktop shortcut for Tableau.
- Create a Start menu shortcut: Clear the check box if you don't want to automatically add a shortcut for Tableau to the Start menu.
- Check for Tableau product updates: Clear the check box if you want to disable the product update feature. This feature checks for maintenance updates and installs them automatically. If you disable this option at install it also disables the menu option for users. For more information about the product update feature, see Control Product Updates for Tableau Desktop.
- Install database drivers: Clear the check box if you don't want to automatically install the database drivers. You can also disable one or more of the drivers from the command line. For more information about this option, see Installer properties(Link opens in a new window).
- Click Install to begin installation. If you run into any difficulties, see Troubleshoot Your Tableau Desktop or Tableau Prep Builder Installation.
After installation is complete, you will need to activate and register the product to begin using it. For more information, see Activate and register your product.
Important: Tableau Prep Builder is designed to work with Tableau Desktop. It is recommended that you install Tableau Prep Builder on the same machine as Tableau Desktop.
Do not install Tableau Prep Builder on the same computer running Tableau Server. Tableau Server Resource Manager (SRM) can't distinguish between Tableau Server protocol server process and Tableau Prep Builder protocol server process. If the computer resources are exhausted, SRM may terminate the protocol server process belonging to Tableau Prep Builder, which has no recovery mechanism.
Do not install Tableau Prep Builder on the same computer running Tableau Server. Tableau Server Resource Manager (SRM) can't distinguish between Tableau Server protocol server process and Tableau Prep Builder protocol server process. If the computer resources are exhausted, SRM may terminate the protocol server process belonging to Tableau Prep Builder, which has no recovery mechanism.
- As an Administrator, log in to the computer where you are installing Tableau Prep Builder.
- Depending on your operating system, do one of the following:
- For Windows: Run the installer and follow the prompts.
- For Mac: Open the Disk image file (.DMG), and then double-click the installer package (.PKG) to start the installation.
- When prompted, accept the licensing agreement to continue the installation.
- To enable or disable usage reporting complete the following steps for your operating system.This option allows us to gather usage pattern data to improve the product. For more information about this option and how to turn it off after installation, see Turn off usage reporting.Windows
- To opt out of providing usage data, select the Don't send product usage data check box.
Mac- On the Installation Type step, in the bottom-left of the install wizard, click Customize. To opt out of sending product usage data, select the Don't send product usage data check box.Note: Starting in version 2019.4.1, only the PostgreSQL driver is installed automatically on the Mac. You can clear the check box if you don't want to install this driver. If you need other database drivers, you can install them from the Driver Download(Link opens in a new window) page.
- (Optional) To customize the install, on the Install welcome screen for Windows or on the Installation Type step for the Mac, click Customize and change any of the following options:
- Install location (Windows only): Specify a different location to install Tableau Prep Builder.
- Create a desktop shortcut: On Windows, clear the check box if you don't want to automatically create a desktop shortcut for Tableau Prep Builder. On Mac, select the check box to automatically create a desktop shortcut for Tableau Prep Builder.
- Create a Start menu shortcut (Windows only): Clear the check box if you don't want to automatically add a shortcut for Tableau Prep Builder to the Start menu
- Enable error reporting (Windows only): If Tableau Prep Builder has a problem and shuts down unexpectedly, crash dump files and logs are generated and placed in your My Tableau Prep Builder Repository > Logs and My Tableau Prep Builder Repository > Logs > crashdumps files.To turn off this option during install, clear this check box during install. To turn this option off after installation see Turn off error reporting(Link opens in a new window).
- Install database drivers: Clear the check box if you don't want to automatically install the database drivers.Important:Tableau Prep Builder is only available in 64-bit and If you already have 32-bit drivers installed, you'll need to install the 64-bit version of those drivers to connect to your data with Tableau Prep Builder.
- Click Install to begin the product installation.
![Tableau Mac Tableau Mac](https://www.ordissinaute.fr/sites/default/files/styles/full_new_main/public/field/image/vignette-loc-creer-un-tableau.jpg?itok=6EDbpInc)
Activate and register your product
Important: The Tableau licensing service was moved to a new data center on October 6, 2018. This means that any environments that required special configuration (static IP safe listing for example) to access licensing.tableau.com or licensing.tableau.com will need to be updated. For more information, see Tableau Community(Link opens in a new window).
After the installation process is finished, the next step is to register and activate your product. Use one of the following options:
- From the user interface: Follow the instructions in this topic. You'll need the product key that you saved earlier. If the computer where you're installing the product has internet access, the installation process walks you through activating the product.
- From the command line: For instructions, see Activate Tableau Desktop and Tableau Prep Builder(Link opens in a new window) and Register Tableau Desktop and Tableau Prep Builder(Link opens in a new window).
- Using Login-based license management: If you are using Tableau Server with a login-based license management enabled product key, you can activate Tableau Desktop and Tableau Prep Builder with one click. For more information, see Login-based License Management(Link opens in a new window).
- Install offline: If you're installing the product on a computer that doesn't have internet access, or if your company firewall or proxy restricts access to the
licensing.tableau.com
site, follow the additional instructions in Activate your product offline to complete the activation process. To activate Tableau Prep Builder offline, you must use Tableau Desktop.
- After the installation process is finished, open Tableau Desktop. This launches the Tableau Registration form where you can register and activate your product.
- Fill out the fields on the registration form and then click Activate Tableau.If you are activating Tableau Desktop as a trial, click Start trial now at the bottom of the screen.
- Select one of the following options:
- Activate with a product key: Use this option if you are activating using the user interface and have a product key.
- Activate by signing into a server:Use this option if you are using login-based license management to activate your product.
- If you are activating with a product key, delete any existing text in the Enter product key field, copy your product key (from the location that you saved it to from the Where's my product key? procedure) and paste it into the text box, then click Activate.A second screen appears to complete the activation process. Click Continue to finish the process.If Tableau can't connect to the site that authenticates that product key, it can't complete the activation and you must activate the product offline. Follow the instructions in Activate your product offline to complete the activation process.
- If you are activating using login-based license management enter the URL for your server and click Connect.Sign into your server, then complete the registration page if needed, and click Register.
- Launch Tableau Prep Builder.
- In the Activation page, select one of the following options:
- Start a trial: Select this option if you don't have a product key but want to try Tableau Prep Builder.
- Activate with a product key: Use this option if you are activating using the user interface and have a product key.
- Activate by signing in to a server: Use this option if you are using login-based license management to activate your product.
- Purchase a license: Select this option to navigate to the Tableau website to purchase a license.
- If you are activating with a product key, delete any existing text in the Enter product key field, copy your product key (from the location that you saved it to from the Where's my product key? procedure) and paste it into the text box, then click Activate.
- Complete the registration form, and then click Register.
- If you are activating using login-based license management enter the URL for your server and click Connect.Sign into your server, then complete the registration page if needed, and click Register.
When your registration is complete, Tableau Prep Builder opens and you can start preparing your data.
New to Tableau Prep Builder? Try the Get Started tutorial(Link opens in a new window) to learn how to build your first flow.
Activate your product offline
Note: If you're upgrading versions and you've paid your maintenance (Tableau Desktop only) since the last time offline activation was completed, contact Tableau Customer Service(Link opens in a new window) via email to get an updated product key before continuing with offline activation.
If you're installing the product on a computer that doesn't have internet access, or if your company firewall or proxy restricts access to the
licensing.tableau.com
site, then you must complete the steps below to finish activating your product. You will need access to another computer that has internet access to complete all the steps in this procedure.To activate Tableau Prep Builder offline, you will need your product key and Tableau Desktop version 2018.1 or later installed on the same computer that is offline.
- In the Activate Tableau dialog, click Activate.
- Tableau prompts you to save a file that you can use for offline activation. Click Save.Note: If you're performing the offline activation process because of firewall or proxy restrictions, you might not be prompted to save the activation file. In that case, manually disconnect the computer from the network and then restart this procedure so that you can be prompted to save the activation file.
- Save the file to a location that you can reach from a computer that does have internet access. Use the default file name (
offline.tlq
). - Click Exit.
- From a computer that has internet access, open a web browser and go to the Activation(Link opens in a new window) page on the Tableau website.
- Complete the instructions for Offline Activation to submit your
offline.tlq
file and create aactivation.tlf
file. - Save the
activation.tlf
file and then copy it to the computer where you installed Tableau Desktop. - On the offline computer, double-click the
activation.tlf
file to perform the offline activation.
- Launch Tableau Desktop.
- From the top menu, select Help > Manage Product Keys.
- In the Manage Product Keys dialog, click Activate.
- Enter your Tableau Prep Builder product key and then click Activate.
- Tableau Desktop detects that you are offline and shows the following message. Click Save to create an activation file.
- Save the file to a location that you can access from the offline computer. Use the default file name (
offline.tlq
). - From a computer that has internet access, open a web browser and go to the Activation(Link opens in a new window) page on the Tableau website.
- Follow the instructions and select the (
offline.tlq
) file that you just created and upload it to create a create aactivation.tlf
file. You will need this file to activate Tableau Prep Builder. - Click Upload Activation File. You should receive a confirmation dialog that the upload was successful.
- In the confirmation dialog click the link to download the activation file to complete the activation process.
- Close Tableau Desktop.
- Launch Tableau Prep Builder. You will be prompted to complete the registration process form to register the product. If you have previously registered a Tableau product, the fields may be populated automatically.
Change default settings
During installation, Tableau configures default settings for your display language and repository location. If you want to change those settings you can do this after install is complete.
Tableau also enables certain features for you by default such as usage reporting or automated product updates (Tableau Desktop only). For information about how to turn off these features and more, see Change Installation Settings after Installation(Link opens in a new window).
Set your display language (optional)
When you first run Tableau Desktop or Tableau Prep Builder, it recognizes your computer locale using the User Locale setting and uses the appropriate language if it is supported. If you are using an unsupported language, the application defaults to English.
You can configure Tableau Desktop or Tableau Prep Builder to display the user interface (menus, messages, etc.) in a different language by selecting Help > Choose Language from the top menu. Restart the application to apply the change.
For Tableau Prep Builder, the display format for numbers and dates is based on the locale of the operating system on the machine where the application is installed. For Tableau Desktop you can configure date and number formatting for your workbooks. For more information see Language and Locale(Link opens in a new window) in the Tableau User help.
Change your My Tableau Repository location (optional)
During install, Tableau Desktop and Tableau Prep Builder automatically creates a My Tableau <application> Repository folder structure in your documents folder on your computer. If you need to move this repository to another location, for example because you are required to have your data on a network server instead of on your local machine, you can specify a new location and point Tableau Desktop or Tableau Prep Builder to the new folder.
When setting a new location for your repository, the following rules apply:
- The new folder must be a directory.
- You must have permissions to write to the new folder.
- The new folder can't be located in the existing My Tableau Repository folder structure.
Note: Changing the repository location does not move the files contained in the original repository. Instead, Tableau creates a new repository where you can store your files.
- Open Tableau Desktop or Tableau Prep Builder.
- From the top menu, select File >Repository Location.
- In the Select Repository Folder dialog, select a new folder that will act as the new repository location.
- Restart the application to use the new repository.