Guys,
I'm struggling with something that should be a quick aggr function with rank.
I have my booking dates and want to show it by WORK DAY. Like the example bellow.
How can I calculate the yellow column?
| BOOKING_DATE | BOOKING_DAY | BOOKING_WORKDAY |
|---|
| 9/2/2014 | 2 | 1 |
|---|
| 9/3/2014 | 3 | 2 |
|---|
| 9/4/2014 | 4 | 3 |
|---|
| 9/5/2014 | 5 | 4 |
|---|
| 9/8/2014 | 8 | 5 |
|---|
| 9/9/2014 | 9 | 6 |
|---|
| 9/10/2014 | 10 | 7 |
|---|
| 10/1/2014 | 1 | 1 |
|---|
| 10/2/2014 | 2 | 2 |
|---|
| 10/3/2014 | 3 | 3 |
|---|
| 10/6/2014 | 6 | 4 |
|---|
| 10/7/2014 | 7 | 5 |
|---|
| 10/8/2014 | 8 | 6 |
|---|
| 10/9/2014 | 9 | 7 |
|---|
| 10/10/2014 | 10 | 8 |
|---|
Thanks,
Fabio
