Tableau TOTAL Function

The Tableau TOTAL function is one of the Table Calculation Functions, which will return the total for the given expression or column in a table based on the Compute using the option in the Table calculation partition. It is one of the most popular Table Calculations applied on top of the aggregate function. This article … Read more

Tableau Count and Distinct Count

In Tableau, there are two aggregate functions called COUNT() and COUNTD() to count and distinct count the records in a Table or a particular section (category or segment). Although they sound the same, the result will differ in most cases. The syntax for using the Tableau Count and Distinct Count is shown below. COUNT(Column or … Read more

Tableau DATEPARSE Function

The Tableau DATEPARSE is one of the date functions that will convert any field (in general string) to the date field based on the date_format and date_string arguments. This article shows how to use this Tableau DATEPARSE function to convert a field to the DATE field and what the alternative approaches (pre-built) with examples. Generally, … Read more

Tableau Concatenate Strings

In Tableau, string concatenation is the process of combining (concatenating) two string fields or columns to create a new field (calculated) to ease the data analysis. While preparing the data to Analyze, string concatenation is the most common operation one will perform. For instance, contact First and Last Name to get the Customer’s Full Name. … Read more

Tableau Cumulative Sum

In Tableau, Cumulative Sum, also known as Running Total, is calculated by adding up the row values in a column in a step-wise manner. The result of the Tableau Cumulative Sum at any step(row) is the sum of all the preceding rows within a column. This article shows how to use this Tableau RUNNING_SUM() function … Read more

Tableau AND Function

The Tableau AND is one of the Logical functions that will perform the logical conjunction between two or more expressions. The AND function will return True if both expressions are evaluated to True. This article shows how to use this Tableau Logical AND function to evaluate multiple expressions within the IF ElSE or IIF statements … Read more

Tableau DATEADD function

The Tableau DATEADD is one of the date functions that will add a user-specified number of intervals to the given date based on the date_part (first) argument. For example, if you pass 5 as the second argument and the year as the first argument, the DATEADD function adds five years to the given date, i.e., … Read more

Tableau ZN function

The Tableau ZN is one of the Number Functions that will return the original expression or values if the cell is not null; Otherwise, it returns Zero. In simple English, the ZN function replaces the NULL values with 0 and prints the Not NULL values as it is.  Remember, this Tableau ZN function only works … Read more

Tableau Dot Plot

Tableau Dot Plot represents the individual data points in the graph where each dot represents the value. It is beneficial to show the multiple data points for each category to analyze the range or change. This article shows how to create a Dot Plot and format the colors, size, etc.  We used the Sample Superstore … Read more

Tableau DATEPART Function

The Tableau DATEPART is one of the date functions that help to extract the part of a given date and returns the integer value based on the first argument, i.e., date_part. For example, if you pass the year as the first argument, the DATEPART function returns the year from Date1. This article shows how to … Read more