Show Closed and opened case in a single chart even though they have 2 different dates

[Anonymous]

I all, I have a table with the headers below for casework:

Case ID	Opened Date	Closed Date	Closed
1	01 Jan 2016	05 Jan 2016	Yes
2	01 Jan 2016	03 Jan 2016	Yes
3	02 Jan 2016	11 Jan 2016	Yes
4	04 Jan 2016	05 Jan 2016	Yes
5	07 Jan 2016	09 Jan 2016	Yes

Because each case is not open and closed on the same case, I can't create a chart showing the net difference between how many cases are opened and closed on a same day. I believe I will have to do something with the script editor but to be honest I am a TOTAL novice when it comes to that (if anybody has any easy-peasy tutorials on it,please send the links over).

how can I make a chart show the number of cases opened vs the number of cases closed on a chart using teh same date dimension?

It should show the below:

- 1st of Jan 2016: 2 opened, 0 closed

- 2nd of Jan 2016: 1 opened, 0 closed

- 3rd of Jan 2016: 0 opened, 1 closed

- 4th of Jan 2016: 1 opened, 0 closed

- 5th of Jan 2016: 0 opened, 2 closed

- etc...

[swuehl · Accepted solution]

Have a look at

Canonical Date

You can also use an approach like

Creating Reference Dates for Intervals

and create flags for open and close dates in the link table. This additionally gives you the data to get the number of open cases (inbetween OPENED and CLOSED date).

edit: a sample for latter can be found in

Help regarding carryon count of tickets

[Anonymous]

The Reference Dates worked a treat!!! thanks!