Some values, such as dates, require special handling in Tableau. If you want to display one of those values in the Rows or Columns shelf, you can change the value type from a measure to an attribute.
- [Presenter] Some values, such as dates,…require special handling and tableau.…If you want to display the values from one of those fields…in the rows or column shelf, you can change the value type…from a dimension to an attribute.…In this movie, I will show you how to do that.…My sample file is the Attribute Workbook,…and you can find it in the Chapter Two folder…of the Exercise Files collection.…I have a series of clients, and the scenario I envision here…is that the clients would like me to give them a proposal…for a cost for hosting a conference at our hotel.…
So over in the dimensions area,…you see that I have dates for projected completion…and when the proposal is required.…If I want to add the Proposal Required field,…which is a date field, to the rows area,…I can drag it there.…And you see that I get the year.…And of course, I can click the Show Detail button…to display the quarter, then the month and so on.…However, if I want to display the entire date,…then I can display the value as an attribute.…
So I will hover my mouse pointer…
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: Find the value of an attribute