In this video, learn how to count the number of distinct items in a set, such as the number of states represented by your hotel’s visitors.
- [Voiceover] Counting things,…the task for which arithmetic was invented,…isn't as glamorous as standard deviations…or percentile rankings,…but it is useful in many business contexts.…In this movie, I will show you how to count…the number of items in a group,…as well as the number of distinct items.…My sample file is the Count Workbook,…and you can find it in the Chapter Two folder…of your Exercise Files collection.…In this workbook, I have a single worksheet,…and on it, I have a visualization that shows…the product category, my five product categories,…and the total of the cost of the orders that were placed…for each of those categories.…
Let's say that I want to see something different,…that I want to see the number of orders…for each of those categories.…If I want to do that, I can go to the Data panel.…And at the bottom, under Measures,…you'll see Number of Records.…And if I drag Number of Records to the Marks card…and put it on top of Text,…then I have the total cost of the orders…and then I have the number of records.…
Author
Curt Frye
Released
4/18/2017- Defining data types and conversions
- Defining function syntax in Tableau 10
- Creating a calculated field
- Creating an ad hoc calculation
- Summarizing data using aggregate functions
- Calculating values using number functions
- Finding the absolute value or sign of a number
- Working with times and dates
- Creating IF THEN expressions
- Managing null values using IFNULL and ISNULL
- Creating level of detail expressions
- Creating a quick table calculation
- Converting and measuring strings
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 14s
-
-
1. Introducing Calculations in Tableau 10
-
Create a calculated field4m 37s
-
Create an ad hoc calculation4m 15s
-
2. Summarizing Data Using Aggregate Functions
-
3. Calculating Values Using Number Functions
-
Round numbers up or down6m 26s
-
4. Working with Times and Dates
-
Truncate a date3m 37s
-
5. Creating Conditional Calculations Using Logical Functions
-
Create IF THEN expressions4m 12s
-
-
6. Creating Level of Detail (LOD) Expressions
-
7. Summarizing Data Using Table Calculations
-
Rank table data3m 54s
-
8. Managing Text Strings
-
Convert and measure strings4m 32s
-
Trim and pad strings1m 28s
-
-
Conclusion
-
Next steps57s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Count all values or distinct values in a data set