Hi wylie,
Hope you're doing well,
I just want to clarify one more thing, now I understand that I have to transform the data but I am not really sure that how should the output summarized data should look like.
A small example data could really help me.
I want this to be achieved in certain scenario : suppose if there are 4 completed states and 3 Ready states on 15th June, the next day we shift 1 workitem from ready state to completed state, now we should be seeing 2 in Ready state and 5 in completed state on 16th June.
And one more scenario can be like if no shifts happens the states remain same with the previous date.
I Believe we have to Transform the data in a way to fit these scenario's right ?
Thanks,
Aswanth.