I have a handful of records:
| ID | Status | StatusDate | Count |
|---|
| 1 | Open | 1/1/13 | 1 |
| 1 | Closed | 1/15/13 | 1 |
| 2 | Open | 1/10/13 | 1 |
| 2 | Closed | 1/30/13 | 1 |
I want to make a barchart that will show every day of the year on the X axis (using a master calendar tied to StatusDate), with a sum of Open records on the Y axis (EVERY DAY).
The above data should show:
1 from 1/1/13 through 1/9/13
2 from 1/10/13 through 1/14/13
1 from 1/15/13 through 1/29/13
Is it possible to do this with just the data above, or do I need to make a new record for every single day of the year, per ID (lots and lots more data)?
Thank you
