Forum Discussion
Solved
Using Different Date to Decide Status
Hi, I'm trying to figure out how to use two different dates to capture two different statuses: 'Open' and 'Closed'. So with my date in the field "Start Date" is when the event was open and the d...
v-henryk-mstf and AllisonKennedy thanks for you help and I figured it out 🙂
I just unpivoted the date columns and wrote a quick conditional column that created the needed status to put both data fields onto the shared axis.
Hi Kmcdonald ,
Whether the advice given by AllisonKennedy has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly.
If not, can you provide some test data so that I can answer for you.
Looking forward to your feedback.
Best Regards,
Henry