Status changes

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

See here