Forum Discussion
Helper Icreate graph from daily data of dataset
Helper IGraph 1: number of work items committed accepted (closed state) / (number of work items planned (closed state need to exlcuded)) e.g: 5/14*100 = 35.71 (only first 5 items are closed and rest of them are newly added)
(14 only items present on 25 Oct which are in not closed state, exclude close state for count) ref sheet 4
Graph 2: number of work items committed accepted (closed state) / (number of work items planned - number of committed work items explicitly removed)
Graph 3: number of work items added / number of committed work items e.g: 9/14 = 64.28
below is example of Q3 S1: start date on 25th Oct and end date on 7th Nov
google link:
Super UserWhat is the significance of the [Date] column in the RRR table?
- bgashok
in RRR Table, Date reflects the workitem status on that particular day and would have all calender days for a durtion.
Currenly pulling report of all workitem status on each day for a specific duration, so that we know the historcal infomration of work items on that particalur day for creating graphs.
- lbendlin
That seems excessive. Have you considered using change tracking instead?