Hi All,
I'm preparing data to show the status of property if it is occupied, with repairs (untenantable) or ready to let (Tenantable). I plan to export the end result to Tableau extract so users can check the property status by week, end of the month or quarter.
I have two tables, one which holds how long the property was vacant and also dates how long it was for repairs and with the allocation team before it is let. The second is the property table which hold property start and end date.I have blended the data and seems like i got the required results but need it to be reviewed to ensure, I have done the workflow correctly and looking for feedback.
Once I join the vacant and property table I then join the datset to a calendar marcro to get the dates (weeks, end of month and quarter). Though the months and quarter dates are correct the week start date and week end date is not as per Australian timezone and wanted help on how to fix the calendar macro.
I have attached the sample workbook and calendar macro and appreciate your assistance.
Thanks
