How to create Crosstab and Motion Chart in Tableau

Last updated on Oct 21 2021
Ramnath Swami

Table of Contents

How to create Crosstab and Motion Chart in Tableau

A crosstab chart is also called a Text table that shows the data in textual form.
The crosstab chart takes one or more dimensions and one or more measures. This chart can also show different calculations on the values of the measures field such as percentage total, running total, etc.
For example, consider a data source such as Sample-Superstore, if you want to find the number of Sale for each Segment in each Region. To display the data for each year using the available Order Dates below are some steps to create a crosstab chart.
Step1: Drag the dimension Order Date into the columns shelf.
Step2: Also, drag the dimensions Region and Segment into the row shelf.
Step3: Drag the measure Sales into the “Labels” shelf under the Marks pane.
The below screenshot shows the crosstab chart.

tableau 109
tableau

In the crosstab chart, you can get the values color encoded by dropping the Sales field into the Color shelf.
The color-coding shows the strength of the color depending on the value of the measure. The highest values have a darker shade of color, and the smaller values have a lighter shade of color, as shown in the below screenshot.

tableau 110
tableau

Also, in addition to the color encoding, you can get calculations applied to the values from the measure.
For example, you can apply the calculation to find the percentage total of sales in each row instead of only the Sales field.
1. Right-click on the Sales field in the Marks shelf.
2. And choose the Add Table Calculation option.

tableau 111
tableau

3. It opens the Table Calculation window.
4. Then, choose the “Percent of Total” option as Calculation Type and “Table (Across)” option as Compute Using.

tableau 112
tableau

After completing the above steps, you get the crosstab chart created with percentage values, as shown in the below screenshot.

tableau 113
tableau

Tableau Motion Chart

Motion chart is used to show the data using X-axes and Y-axes that display the change over time by showing the movement of the data points as well as variations in the color of the lines.
The motion chart has the advantage to view the trail of how the data has changed over time.
Motion chart needs only one Time Dimension and one Measure in tableau.
For example: consider the data source such as Sample-Superstore, and if you want to find the variation of Profits over the Months. For this, there are the following steps given below, such as.
Step1: Drag the Dimension Order Date into the Columns Shelf.
Step2: Again, drag the dimension Order Date into the Pages Shelf.
Step3: Right-click on the Order Date field in the Pages shelf, and choose Month option.
Step4: Then, drag the measure Profit to the Rows Shelf. And appear chart Shown in the below screenshot.

tableau 114
tableau

Step5: Put a checkmark in the box next to “Show History” button and then click on the dropdown arrow next to it.

tableau 115
tableau

Step6: For “Marks to Show History For” option, select All. And under “Show” option, you can select Both, Marks option shows only the points and also selects Trails option shows only the line. Click the Pslay button and below chart appears.

tableau 116
tableau

After allowing the chart to run from January to December, it creates a chart that shows how profits varied over each month in the whole year.
According to the appear chart, the data changes in the recent month get a dark shade of the color, and the historical data gets a light shade of the color. You can see in the below screenshot.

tableau 117
tableau

So, this brings us to the end of blog. This Tecklearn ‘How to create Crosstab and Motion Chart in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau
• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface
Data Connection with Tableau Desktop
• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online
Basic Visual Analytics
• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets
Advanced Visual Analytics
• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering
Calculations in Tableau
• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations
Level of Detail (LOD’s) Calculations
Advanced Charts in Tableau
• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
Parameters
• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line
Dashboards and Stories
• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points
Data Security in Tableau
Optimizations tips and tricks
Interacting with Tableau Server
Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "How to create Crosstab and Motion Chart in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *