Hello!
I am attempting to combine two date fields so that they can be plotted on the same axis.
My current data set is formatted like this:
Incident | Assigned to | Opened Date | Resolved Date |
12345 | Joe | 1/1/2017 | 1/6/2017 |
23456 | Linda | 2/2/2017 | 4/1/2017 |
34567 | Bob | 3/3/2017 | 3/7/2017 |
My hope is to format it like this:
Incident | Assigned to | Date | Date Type |
12345 | Joe | 1/1/2017 | Open |
12345 | Joe | 1/6/2017 | Resolved |
23456 | Linda | 2/2/2017 | Open |
23456 | Linda | 4/1/2017 | Resolved |
34567 | Bob | 3/3/2017 | Open |
34567 | Bob | 3/7/2017 | Resolved |
Can anyone help me to do this? I cannot seem to find the right tool.
Solved! Go to Solution.
Hey @aaltaffer! I would split the data into two different streams, the left only keeping the open date and the right only keeping the resolved date. I would rename the date fields as just 'Date'. Then, I would add a Formula to each stream that creates a Date Type field with the value "Open" in the one stream and "Resolved" in the other. Adding a Union will result the format you're wanting. Hope this helps!
This worked! Thank you!
Thank you this is another great solution