## Blog

Blogs

### Show City & State Data on One Tableau Map

Step 1: Double Click [State] to create a map. Double click [City] Step 2: Right click [Sales] and create a calculated field. You will need

Blogs

### How to Find the Correlation for an Aggregated Value in Tableau Using a Window Function

How do you find the correlation of two aggregated values in tableau in this example I have a scatter plot of kpi and kpi2 and

Blogs

### How to Highlight the Max Value in Tableau

How do you highlight the max value in tableau in this example I have a table with kpi business line and product and i’ve highlighted

Blogs

### Tableau: RANDOM() Jitter Plot

Step 1: Drag [Sales] to the rows shelf, and [Region] to the columns shelf. Step 2: Click Analysis, and unselect “Aggregate Measures”. This will result

Blogs

### Tableau: How to Filter Dates While Calculating % Difference

Filters can cause problems when using table calculations in Tableau. Here’s a trick to use a filter while also using table calculations. We’ll use the

Blogs

### How to Format Positive and Negative Values in Tableau Using Color and Custom Formats

How do you format positive and negative values in tableau in this example I have sum of profit by state and region and I’m showing

Blogs

### Tableau: How to Display Correct Grand Total with a Rank Filter

Step 1: Start with [State] on rows, and sum([Sales]) on Text. Step 2: Create a rank calculation. Rank(Sum([Sales])) Step 3: Add the calculation to the

Blogs

Step 1: Build a scatter Plot using a metric on columns and a metric on rows. Unselect aggregated measures to finalize the scatter plot. Step

Blogs

### How to add Month Over Month to a Line Chart

Step 1: Start by adding Month to columns, and Sales to rows. This will give you a line chart. Step 2: Hold the control key

Blogs

### Tableau: Create a Gantt Chart using Start & End Dates (Scaffold)

Step 1: Create a Dates Table Step 2: Join the dates table with your data on [Start Date] <= [Date] and [End Date] >= [Date]

Blogs

### Tableau: How to Solve “Cannot Mix Aggregate and Non-Aggregate” Errors

Let’s start with a simple example. Within a single calculation, all parts of a calculation must be either aggregated or not aggregated. This calculation is

Blogs

### Tableau: Compare Same Period Last Year

Step 1: Create a crosstab by dragging order date to rows, and sales to the text shelf. In this data, we only have December 2019

Blogs

### Tableau: Control Date Level with Parameters (Year, Month, Quarter)

Step 1: Build a dual axis chart using [Date], [Quantity], and [Sales]. The result will be a combined bar and line chart. Step 2: Create

Blogs

### Tableau: How to create a Side by Side Bar Graph with Overlaying Line Chart

Step 1: Select all of your metrics. Right click one of them. Select Transform > Pivot. This will give you pivot field names and pivot