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 |