Overspent days in planned days

babynus wrote: Why have it on planning element as you have it on Activity ?
(this is a 1on1 link between both)

Sorry, rather in in PlannedWork or in Work table, so to have the flag set on specific days (or portion of days)

Would it be easier to have 1 field in work and plannedwork table that would indicate the progress in the activity ? (so for Activities only)
Progress in number of days would be ok : in an entry of work/plannedwork table, one field would indicate the number of days already done or planned before this planned or worked day.

Example :
An activity is assigned for 5 days, and the following lines are created in plannedwork :
day 1 : progress=0
day 2 : progress=1
day 3 : progress=2 (only 0.5d planned on that day)
day 4 : progress=2.5
day 5 : progress=3.5
day 6 : progress=4.5 (only 0.5d planned on that day)

Would it be easier to do ?


The alternative, for me, would be to add extra code in the report : do a select for each activity that I want to display, to retrieve all days planned for this activity and do my own calculation to find when we reach the number of validated work. But this would be very time consuming on large reports.


Note : this is a use case we have, and I also saw this exact kind of reporting in Sopra. A lot of other companies must think this way too probably.
The KPI is : the number of "billed days" each month (or week)
And by "billed days", it means : days spent on activities billed to the client. So if only 5 days have been sold, the 6th days is considered as non billable. In Sopra those extra days are called TNF (Temps Non Facturé)

babynus wrote: What you propose will not work.
It will if you enter days correclty day by day and never enter work backward.

OK that's true :-/

babynus wrote: But instead of thinging of the solution, what exactly do you need ?
A display of "extra worked days" in red.
For sure it will not be done on Gantt : this display is already heavy to draw, and will not be completed with such details.
So maybe you need a specific report.

But if you just need the "TNF" information, it is just a negative margin. So data is displayed and highlighted.

Yes we already have various interesting project reports, and in particular reassessed work vs validated work. That is great for project management.

But we need a view that is more oriented on the team management : work "produced" by the team every month.
So the important KPI is : the "billed days" per month and this is what is difficult

Here is the team view that I try to build for each month :


The "billable" info is what I need to measure, and this is directly linked to the number of "overspent days" in the month.