Crosstabs are Tableau visualizations that arrange data with headers for both rows and columns. In this video, learn how to create a crosstab.
- [Instructor] Tableau lets you analyze large data collections efficiently. In this movie, I will show you how to create a summary or visualization that Tableau refers to as a cross tab. As my sample file, I will use the 08_01_crosstab workbook, which you can find in the chapter eight folder of the exercise files collection. To create my visualization, I will use a number of fields. The first that I'll use, and I'll add this to the data area, is the number of records. In this case, we have a table that is keeping track of the number of orders that have been placed, so number of records will give us the number of records for the values we assign to the column and row labels. So I will drag number of records to the data area, and we see the total is 274. Now let's say that I want to go by product name and by year. I will drag product name to the row's shelf. So I've got that, and then for columns, I will do order date. And rather than just breaking it down by year, I will click the plus sign in the year pill and that changes to quarterly. Every cell in this cross tab is at the intersection of a row and a column. So if I wanted to find sales for lemon by the bottle, for Q2 of 2018 here, and go down until I find lemon by the bottle. And you can see that I have a tool tip indicating I'm in the right place. So lemon by the bottle in quarter number two of 2018 saw eight individual orders. We don't know anything about the quantity, but we do know the number of orders. So as you can see, this cross tab layer arrangement allows you to look up values as long as you know the value in the row and the value for the column.
- Managing data sources and visualizations
- Managing Tableau worksheets and workbooks
- Displaying source metadata
- Creating custom calculations and fields
- Analyzing data using statistical tools
- Sorting and filtering Tableau data
- Defining groups and sets
- Creating and pivoting crosstabs
- Formatting Tableau visualizations
- Creating basic charts
- Annotating and formatting charts
- Mapping geographic data
- Creating dashboards
- Methods for defining an URL-based action
Skill Level Beginner
1. Introduction to Tableau
2. Manage Data Sources and Visualizations
3. Manage Tableau Worksheets and Workbooks
4. Create Custom Calculations and Fields
5. Analyze Data
6. Sort and Filter Tableau Data
7. Define Groups and Sets
8. Develop and Pivot Crosstabs
9. Create Basic Visualizations
10. Format Tableau Visualizations
11. Annotate and Format Visualizations
12. Map Geographic Data
13. Build Dashboards and Actions
14. Tableau 2019.2 Updates
Define parameter actions4m 43s
Next steps1m 6s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.