1 Reply Latest reply: Mar 21, 2013 6:47 AM by Gysbert Wassenaar RSS

    Status changes

    David Koschei

      I have a handful of records:

      IDStatusStatusDateCount
      1Open1/1/131
      1Closed1/15/131
      2Open1/10/131
      2Closed1/30/131

       

      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