Colored Map By Dimension using Tableau Software – video Skill Pill

Colored Map By Dimension using Tableau Software

A Colored Map by Dimension is a chart that helps us to see what dimension is present in one state or country. It can be combined with any type of top analytics or any filters. Watch our video:

In order to create a Colored Map by Dimension in Tableau, please follow these steps:

Step 1: Connect to data

      1. In Tableau Desktop, connect to Superstore sample data provided by Tableau.
      2. Step 2: Create the visualization
      3. Create new Calculated Field Sales by State and Sub-Category with formula: { FIXED [State],[Sub-Category]:SUM([Sales])}.
      4. Create new Calculated Field Highest SC by State with formula: { FIXED [State]: MAX([Sales by State and Sub-Category])}.
      5. Create new Calculated Field Highest SC with formula: if [Highest SC by State]=[Sales by State and Sub-Category] then [Sub-Category] end, from Tableau interface, your business intelligence data reporting and visualisation software.
      6. Drag the State field on Detail from Marks
      7. Drag the Highest SC field on Filter check the Exclude box and exclude the “Null”
      8. Drag the Highest SC field on Color from Marks
      9. Select Map type of visualization from Marks area.

    By Mara Cîșlariu

    Download Tableau Software