How to create time calculations based on dates.
- [Narrator] In this example, we'll look at…how we can use a calculation to find…the difference between two order dates…and then covert that into days, hours,…minutes and seconds.…First, let's have a look at our example data.…We have a number of orders,…the time it was ordered, and the…time it was shipped.…Now, we want to know duration between…the order time and the shipping time.…To do that, first we're going to…calculate the number of seconds,…then we're gonna convert the number…of seconds into days, hours, minutes.…
The first step, we need to know the number…of seconds between the time ordered…and the time shipped.…So let's create a calculated field…and we're gonna use the DATEDIFF function.…So DATEDIFF will take a part of a date,…so we want to look at seconds.…We need to give it the start date,…so that's time ordered, and the end date,…which is the time shipped.…And we'll call this seconds.…
If we add this to our view,…we can see the total number of seconds…between the order date and the ship date.…Now we need to convert the number of seconds…
The training starts with one of the most important features in Tableau: the difference between the green and blue pills (discrete and continuous data) and how this affects every single action Tableau performs. Then find out how to add new maps and create more effective dashboards that maximize screen real estate. Discover how actions can link together sheets and provide greater levels of interactivity and performance, and how formatting can make an ordinary dashboard demand attention. Plus, get some bonus tips on performing date and time calculations in Tableau. This course deep-dives into the practical, applicable, and essential skills that anyone doing data visualization and analytics in a professional setting needs to have.
- Green vs. blue pills
- Using filters, colors, and dates
- Connecting to data
- Extracting data
- Cleaning and prepping data
- Pivoting data
- Merging and joining data
- Highlighting data
- Using the Analytics pane
- Creating new maps
- Creating calculations based on parameters
- Designing dashboards
Skill Level Intermediate
Creating Interactive Dashboards in Tableauwith Nate Makdad1h 38m Intermediate
Data Visualization for Data Analystswith Bill Shander1h 31m Beginner
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
- 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.