Is it possible to modify your data structure? If there is any provision then it'll be very easy for you to get the desired output. You have to transpose you Event Dates into rows for each event. After transpose it should look like.
Sample workbook has been attached for your reference. Have a look and let me know If you've any query.
Sample.twbx 19.0 KB
Thanks for your response.
On first note, I would keep changing the data structure to be the last choice.
Moreover, I did see the workbook. But my requirement/clarification is different from the one that you have shared.
My requirement for point#2 is to
Number of Events by Outgoing Event Date Quarter. i.e. (Outgoing Event Date= Event Closed Date when status is closed & Event Cancelled Date when event status is Cancelled)
I have created a calculated field for the same & plotted the line graph in my attached workbook. However I was unable to change the color for the same to distinguish between the point#1. Kindly let me know if this can be done.
This is bit tricky. The below will depict more on the calculation for the input given.
For 2016 Q1
Cumulative Open Events = Number of Events Open - Number of Events Closed/Cancelled for 2016 Q1
For 2016 Q2
Cumulative Open Events = (Number of Events Open - Number of Events Closed/Cancelled for 2016 Q2) + Cumulative Open Events for 2016 Q1
For 2016 Q3
Cumulative Open Events = (Number of Events Open - Number of Events Closed/Cancelled for 2016 Q3) + Cumulative Open Events for 2016 Q2
& is is calculated so on..
For the given input, I have manually calculated the cumulative Open Events as below.
Number of Events Open Number of Events Closed/Cancelled Cumulative Open Events 2016 Q1 3 0 3 2016 Q2 3 1 5 2016 Q3 3 2 6 2016 Q4 3 2 7 2017 Q1 3 2 8 2017 Q2 3 1 10 2017 Q3 2 0 12
I have created the chart in excel for the same it looks to be.
Kindly help me doing it in Tableau.