From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Add or subtract intervals from dates

Add or subtract intervals from dates - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Add or subtract intervals from dates

“

- [Instructor] Many events happen at regular intervals, such as every week, month, or year. In some cases, events can happen every eight or 10 days, or a client might have 45 days to respond to a proposal. Calculating long strings of dates by hand can be cumbersome, so Tableau allows you to make the calculation easier by creating a formula to add a set interval or increment to a date. I'll show you several ways to perform those tasks. My sample file is the AddDates workbook, and you can find it in the chapter four folder of your exercise files collection. Let's say that you want to add 45 days to a date. In the scenario that I have envisioned here in the workbook, I'm assuming that clients have contacted my hotel about hosting a conference and we have a proposal required date that I've already filled in. And what I want to do is to calculate a time 45 days in the future where we would expect a reply. To add 45 days to an existing date I can create a calculated field. So I'll go to the…

Contents