How to combine two fields in tableau

This recipe helps you combine two fields in tableau

Recipe Objective:- How to combine two fields in tableau?

Step 1:-

Import the dataset named "Global superstore" excel file in the data source.

Step 2:-

Drag and drop the orders sheet in the schema pane.

Step 3:-

Go to sheet1, where dimensions and measures are shown. Click on the country dimension with the ctrl key also select the city dimension.

Step 4:-

Click on the drop-down at the city dimension, click on create, click on the combined field.

Step 5:-

A combined field named "Country & City" will be appeared under the dimensions.

Step 6:-

When clicked on drop-down at the "Country & City" dimension, an option of edit combined field is also provided where the combined fields can be seen.

Step 7:-

Now drag and drop the Combined field of "Country & City" in the row shelf and sales (sum of sales) in the columns shelf. By default, a Bar chart will be seen in the canvas, consisting of country and city combined field names separated by a comma.

Step 8:-

The visualization can be changed to text tables under the show me tab for better understanding.

What Users are saying..

profile image

Ed Godalle

Director Data Analytics at EY / EY Tech
linkedin profile url

I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More

Relevant Projects

LLM Project to Build and Fine Tune a Large Language Model
In this LLM project for beginners, you will learn to build a knowledge-grounded chatbot using LLM's and learn how to fine tune it.

Recommender System Machine Learning Project for Beginners-3
Content Based Recommender System Project - Building a Content-Based Product Recommender App with Streamlit

Build Piecewise and Spline Regression Models in Python
In this Regression Project, you will learn how to build a piecewise and spline regression model from scratch in Python to predict the points scored by a sports team.

Build a Graph Based Recommendation System in Python-Part 2
In this Graph Based Recommender System Project, you will build a recommender system project for eCommerce platforms and learn to use FAISS for efficient similarity search.

MLOps Project for a Mask R-CNN on GCP using uWSGI Flask
MLOps on GCP - Solved end-to-end MLOps Project to deploy a Mask RCNN Model for Image Segmentation as a Web Application using uWSGI Flask, Docker, and TensorFlow.

Ola Bike Rides Request Demand Forecast
Given big data at taxi service (ride-hailing) i.e. OLA, you will learn multi-step time series forecasting and clustering with Mini-Batch K-means Algorithm on geospatial data to predict future ride requests for a particular region at a given time.

Stock Price Prediction Project using LSTM and RNN
Learn how to predict stock prices using RNN and LSTM models. Understand deep learning concepts and apply them to real-world financial data for accurate forecasting.

Classification Projects on Machine Learning for Beginners - 2
Learn to implement various ensemble techniques to predict license status for a given business.

Build a Multi-Class Classification Model in Python on Saturn Cloud
In this machine learning classification project, you will build a multi-class classification model in Python on Saturn Cloud to predict the license status of a business.

MLOps using Azure Devops to Deploy a Classification Model
In this MLOps Azure project, you will learn how to deploy a classification machine learning model to predict the customer's license status on Azure through scalable CI/CD ML pipelines.