Forum Discussion

Kmcdonald's avatar
Kmcdonald
Helper III
4 years ago
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...
Need Help
  • Kmcdonald's avatar
    Kmcdonald
    4 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Kmcdonald ,

 

You can upload attachments by other means, and then just provide a link to the shared file on the forum.


Looking forward to your reply.


Best Regards,
Henry