Posts

Showing posts from March, 2023

How To Create Pareto Chart In Tableau

Image
  How To Create Pareto Chart In Tableau Drag Profit to Rows and Product Name to Columns.  Click the Sort Desc icon at the top below the Analysis menu.  Click on Profit and then hold down the ctrl key and drag a second instance of the pill to the right on the Rows shelf.  Click the down arrow on the of the second Profit pill. Click Add Table Calculation.    In the calculation type, select Running Total.  Leave all the other defaults.  Click the down arrow again on that second Profit pill.  Click “Edit Table Calculation.”  In the window that pops up, check the box in the bottom left that reads “Add Secondary Calculation.”  In the Secondary Type box, select Percent of Total.  Leave the other defaults.    Close the box.  You’ll now have two charts, one on top of the other.  The first has your profit sorted by product in descending order.  The second shows the percent of the total profit that each individual product contributes.  So if total profit was $500 and Product A had a profit of $10

How to Create Waterfall Chart in tableau

Image
  What is Waterfall Chart? A waterfall chart represents a gradual transition of field values from a start value to end value showing a running total with successive increments and decrements. In a normal running total, we cannot see the contribution of each category or contributing factor to the whole value. But, in a waterfall chart, we can see how each category’s positive value increments the total value and the negative ones decrement it and then finally leads to a resultant value. This allows for an insightful analysis of how individual elements of dimensions or measures are contributing to bringing a total value of something. Have you checked the  Tableau Donut Chart  recipe for maintaining your data accurately? How to Create Waterfall Chart in Tableau? Follow the steps given below to create a waterfall chart in Tableau Desktop: Step 1: Open a New Worksheet in Tableau Desktop Open a new worksheet in your Tableau Desktop. Make sure that you already have your dataset downloaded. We

How to Create Bump Chart in Tableau

Image
  How to create a Bump chart in Tableau? In this section, we will learn in a stepwise manner how to create a bump chart in Tableau. Follow the steps given below and make your first bump chart in Tableau. Step 1: Add dimension and measures To start creating a bump chart, open a new worksheet in your Tableau Desktop or whichever version of Tableau you are using. Firstly, we need to add two dimensions and a measure. From our dataset (sales of an electronics store), we add Order Date and Region from the  Dimensions  section and Sales from the  Measures  section. Note that we add YEAR(OrderDate) into  Columns  section, SUM(Sales) into  Rows  and Region into the  Color  box of Marks pane. Step 2: Select a Quick Table Calculation Right-click on the SUM(Sales) field to access options for it. From the drop-down list, we select a  Quick Table Calculation  option and then select  Rank . Step 3: Select a field to compute Next, we right-click on the SUM(Sales) field to access options for it. From t

How to Create Symbol Map

Image
  Introduction Tableau has extensive mapping capabilities with multiple configurations to represent data geographically. A  symbol map  is a chart type in which quantitative values can be represented for various locations on a map utilizing built-in or custom symbols. To make the visual intuitive for the user, the size, color, and shape properties of the symbols can be leveraged. In this guide, you will learn how to create symbol maps in Tableau along with some relevant use cases. Assigning Geographic Roles To plot a geographic dimension like country or state on a map, the text field in the dataset must be assigned a corresponding geographic role. Right-click the dimension in the sidebar and choose a geographic role, as shown below.  The  abc  symbol beside the dimension is changed to a globe once the geographic role is assigned, as shown below. The corresponding latitude and longitude coordinates are generated automatically by Tableau's built-in map server once the geographic role