Preppin Data — 2019W03
Other Operators apart from =, <> under join condition
Make sure you use both sheets. Use one sheet to help you create a row of data for each month the person’s contract is ‘live’ for.
- Tableau can create more columns but it cannot directly create rows. So, try to join the 2 sheets and generate more rows.
- Now the contract length column is unnecessary and can be discarded.
- Use the length column to generate each month from start date till last month
I had to redo this calculation as I have initially missed the -1, as it signifies the start date.