How can I create a Time dimension that is related to DATE_ALERT_CREATED and DATE_ALERT_COMPLETED at the same time as I want to show the created and completed alerts in the same graph on the same Time dimension.
I had initially created a Time dimension this way but I know it is wrong:
NEW_DATE:
LOAD
DATE_ALERT_CREATED,
Year(DATE_ALERT_CREATED) as Year,
Month(DATE_ALERT_CREATED) as Month,
Date(MakeDate(Year(DATE_ALERT_CREATED), Month(DATE_ALERT_CREATED)), 'MM-YYYY') as Date_New
Resident ALERT_TABLE;
I hope I was clear enough, looking forward to your help ! Thank you !