One of the most straightforward ways to analyze data is to determine whether one value is larger or smaller than another.
- [Instructor] One of the most straightforward ways…to analyze data is to determine whether one value is larger…or smaller than another.…This comparison can be useful…when you have two estimates for cost…and want to be sure you used a larger one or a smaller one…to plan your budget for the next year.…In this movie, I will show you the functions used…to find the larger or smaller of two values.…My sample file is the LargerOrSmaller workbook,…and you can find that in the Chapter03 folder…of the exercise files collection.…
In this workbook, I have a single sheet…and it indicates the target spending, that is the budget,…and the actual spend for the previous year,…with four or five categories...…Furnishings, Housekeeping, Maintenance,…Office Supplies and Public Areas.…What I'd like to do is to use either the larger or smaller…of these numbers for planning for the next year.…To create those calculations,…I need to create a calculated field.…So I'll open the Analysis menu…and click Create Calculated Field.…
And I'll name this calculation IdentifyLarger,…
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: Identify the larger or smaller of two values