How to Build a Pareto Chart with Tableau
Step 1: Drag sum(sales) onto the row shelf. Add your dimension to the column shelf. In this case, we’re using state. Step 2: Sort your...
Step 1: Drag sum(sales) onto the row shelf. Add your dimension to the column shelf. In this case, we’re using state. Step 2: Sort your...
Step 1: Drag sum(sales) onto the label mark. Step 2: Drag another sum(sales) to the detail mark. Change the aggregation to average ...
Step 1: Build a diverging bar chart by using profit on the column shelf and state on the row shelf. Step 2: Duplicate that sheet. Move...
Step 1: Drag month of date to columns, and region to rows. Step 2: Create a calculated field called rank. Rank(sum([Sales])) Step 3: Add...
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 and...
Step 1: Drag [Quantity] to columns, [Category] to rows, and [Sub-category] to rows. This will create a bar chart. Step 2: Add...
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 down, and drag...
Step 1: Start with three sheets. A Bar Chart, Line Chart, and a Map View. Step 2: Set your objects to Floating. Drag in a vertical...
Step 1: Create two sheets in Excel. One for your data, and one for your lookup table. Step 2: Connect to your excel datasource. Step 3:...
Step 1: Build a scatter Plot using a metric on columns and a metric on rows. Unselect aggregated measures to finalize the scatter...
Step 1: Double Click [State] to create a map. Double click [City] Step 2: Right click [Sales] and create a calculated field. You will...
Step 1: Drag [Sales] to the rows shelf, and [Region] to the columns shelf. Step 2: Click Analysis, and unselect “Aggregate Measures”....
Let’s start with a simple example. Within a single calculation, all parts of a calculation must be either aggregated or not aggregated....
Step 1: Build a bar chart using Month([Date]) and sum([Sales]) Step 2: Create a new parameter as an integer. Set the default value to 12...
Filters can cause problems when using table calculations in Tableau. Here's a trick to use a filter while also using table calculations....
Parameter actions are a powerful tool to swap metrics in Tableau. A parameter action can be added to most sheets within a dashboard or...
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...
Spark lines are often used in Tableau to show a large amount of date in a small area. They are tiny line charts that are added to the...
Step 1: Build a line chart using [Date], and [Sales] to show 2020, and 2019 sales by month Step 2: Add an initial Year over year...
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...