Comparison Graph - Looking for an Idea!

[Ildestino]

Dear Sirs and Madams,

I am trying to build a comparison graph and I am kinda running out of Idea...

I would like to track activities that are open. To simply the setup I have done an example of what I want to have as a Graph:

Date	Task	Responsible	Status
Monday	Cleaning	Adam	Done
Monday	Shopping	Anna	Open
Wednesday	Cleaning	Anna	Open
Wednesday	Shopping	Adam	Open
Wednesday	Shopping	Anna	Open

<tbody>
</tbody>

Now, as you can see on the last line, Anna got again the Task of Shopping, because Anna didnt do it on Monday, hence she has on Wednesday 2 tasks, Cleaning and Shopping.

What I need is a graph comparing and showing that Anna has 2 Tasks to do on Wednesday, due to the fact that, she didnt do the Shopping on Monday.

I hope, I explained it very well.

Thank you very much in advance.

Kind regards

Ildestino

 

[oldbrewer]

If monday shopping is open then Anna needs to do one shopping chore to clear it, over and above the new chore on Wed.

easy to have a table showing how many outstanding chores for each person. Would that do ?

 

[oldbrewer]

Date	Task	Responsible	Status	DAYS LATE
Mon Feb 05	Cleaning	Adam	Done
Mon Feb 05	Shopping	Anna	Open	2				STATUS	Wed Feb 07
Wed Feb 07	Cleaning	Anna	Open	0
Wed Feb 07	Shopping	Adam	Open	0
Wed Feb 07	Shopping	Anna	Open	0				Open
							Adam	1
							Anna	3

<colgroup><col><col><col><col><col><col span="4"><col><col span="2"></colgroup><tbody>
</tbody>