I’m working on a project where I need to visualize total referrals and total admissions side by side in a single widget. I have two separate date fields: one for Referral Date and another for Admission Date. I want to combine these two date fields into a common date column that allows me to analyze both metrics year-over-year.
Here’s what I’m aiming to achieve:
- Create a unified date column that can pull values from both the Referral Date and Admission Date.
- Display total referrals and admissions in a single widget, organized by year.
I’m unsure of the best approach to create this combined date field in Tableau. Should I use calculated fields, a union of datasets, or some other method?
Any guidance or examples on how to achieve this would be greatly appreciated!
The 2 dates are independent fields that need to be placed on a single calendar - that is done with a date scaffold - see the first example here https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/ it will walk you through the process
