Rather than adding up value totals, Tableau lets you find how many of an item, and how many unique items, appear in a field. In this video, learn how to count occurrences and distinct items.
- Large data collections tend to contain a lot of repeated values. One way to analyze your data is to discover the number of orders placed for a product in a specific category or by counting the number of distinct items within each category. In this movie, I will demonstrate how to perform both of those tasks. My sample file is 0502 count and you can find it in the chapter five folder of the exercise files collection. In this visualization, I have put product category on the rows shelf and I don't have any data in the middle yet. But let's say that I want to count the number of orders within each product category. I know from examining my data set that each row in the data set represents an individual order, so I can count the number of records. To do that, I'll go down to the measures section of the data panel and drag number of records to the data area and there, I can see the number of records. I have 912 orders that included blueprints, 1296 for eBooks, and so on. What that doesn't tell me, however, is the number of items within each category. To do that, I need to create a calculated field. So I will go to the analysis menu and then, about three quarters of the way down, I'll click create calculated field. So I'll change the name from calculation one to distinct products, then I'll click in the editing area below that and I need to use the count D function. So it'll be C-O-U-N-T D, so that's count distinct. And then I want to work on the product name field, so I'm counting the number of products, so type a left square bracket. P-R-O-D name. All right, it's saying indicator is saying the calculation is valid. I'll go ahead and click okay. And there I have my new measure for distinct products, so I will drag some of number of records away and I will drag distinct products to the data area and there, I see the count of the number of products within each of my categories. Ten blueprints, seven drone kits, and so on.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- 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.