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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Task[/TD]
[TD]Responsible[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]Cleaning[/TD]
[TD]Adam[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]Shopping[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]Cleaning[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]Shopping[/TD]
[TD]Adam[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]Shopping[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[/TR]
</tbody>[/TABLE]


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]

[TABLE="width: 991"]
<colgroup><col><col><col><col><col><col span="4"><col><col span="2"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Task[/TD]
[TD]Responsible[/TD]
[TD]Status[/TD]
[TD]DAYS LATE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon Feb 05[/TD]
[TD]Cleaning[/TD]
[TD]Adam[/TD]
[TD]Done[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon Feb 05[/TD]
[TD]Shopping[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STATUS[/TD]
[TD="align: right"]Wed Feb 07[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed Feb 07[/TD]
[TD]Cleaning[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed Feb 07[/TD]
[TD]Shopping[/TD]
[TD]Adam[/TD]
[TD]Open[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed Feb 07[/TD]
[TD]Shopping[/TD]
[TD]Anna[/TD]
[TD]Open[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Open[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Adam[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Anna[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]