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.
v-henryk-mstf I love to attach the file but there isn't any options to do so in the forum...
Kmcdonald You can use Onedrive link to share files, or just past a small table directly in the post so we can copy. Screenshots of what isn't working like you've been sending are helpful too. I managed to dig up my clustered stacked bar chart. Hope it helps.
Here's the source data to save into csv if you want to edit it:
Account Manager CY A CY B PY A PY B CY Total PY Total Territory 1 800000 2300000 1000000 3000000 3100000 5300000 Territory 2 400000 3000000 800000 4000000 3400000 7000000 Territory 3 180000 3000000 300000 2000000 3180000 5000000 Territory 4 150000 1600000 300000 2000000 1750000 3600000 Territory 5 150000 1600000 300000 2000000 1750000 3600000 Territory 6 150000 1400000 300000 1000000 1550000 2400000 Territory 7 80000 1400000 300000 1500000 1480000 2900000 Territory 8 10000 100000 100000 1200000 110000 1300000 Territory 9 10000 100000 200000 600000 110000 700000 Territory 10 10000 0 50000 0 10000 0 Territory 11 0 0 0 0 0 0 Territory 12 0 400000 0 600000 400000 1000000 Territory 13 0 400000 0 600000 400000 1000000 Territory 14 0 150000 0 200000 150000 350000
