Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Have a look at
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
Have a look at
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
The Reference Dates worked a treat!!! thanks!