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.