Before we get started with some examples, let's consider a sample dataset that will be used for the examples in this chapter. It's simple and small, which means we will be able to easily see how the calculations are being done.
This dataset is included as Vacation Rentals.csv in the Learning TableauChapter 04 directory of this book's resources, and is also included in the Chapter 4 workbook as a data source named Vacation Rentals:
|
Rental Property |
First name |
Last name |
Start |
End |
Discount |
Rent |
|
112-Avalon Coast |
Mary |
Slessor |
Dec 2 |
Dec 9 |
$150 |
$1,500 |
|
112-Avalon Coast |
Amy |
Carmichael |
Dec 9 |
Dec 15 |
$0 |
$1,500 |
|
155-Beach Breeze |
Charles |
Ryrie |
Dec 2 |
Dec 9 |
$260 |
$1,300 |
|
155-Beach Breeze |
Dwight |
Pentecost |
Dec 16 |
Dec 23 |
$280 |
$1,400 |
|
207-Beach Breeze |
Lewis |
Chafer |
Dec 9 |
Dec 23 |
$280 |
$2,800 |
|
207-Beach Breeze |
John |
Walvoord |
Dec 2 |
Dec 9 |
0 |
$1,500 |
The dataset describes several vacation rental properties, the renters, the start and end dates of the rental period, the discount, and the rent.