Handling multiple dates in X axis Time dimension

[#1]

Hello all,

I would like to create this bar chart:

But my datatable is this way:

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 !

[sunny_talwar]

Look into this thread:

Canonical Date