Thanks for your responses.
I am interested in your code Tod, if i can help you with anything just
let me know.
I found something on the help guide:
"" I have added a few custom fields to track roughly the amount of
work spent on each ticket. One field is the estimated work (in days)
and the other is the actual work (in days). I needed a simple report
to summarize the total amount of work for each milestone: estimated
and actual.
trac.ini:
[ticket-custom] estimate = text estimate.label = Estimate
actual = text actual.label = Actual
Custom SQL:
SELECT
milestone AS Iteration, SUM(estimate.value) AS Estimate, SUM
(actual.value) AS Actual
FROM ticket t
LEFT OUTER JOIN ticket_custom estimate ON
(t.id=estimate.ticket AND estimate.name='estimate')
LEFT OUTER JOIN ticket_custom actual ON
(t.id=actual.ticket AND actual.name='actual')
GROUP BY milestone
""
maybe that could also help.
Keep the good work !!!
Andrés Amaya Díaz
On Aug 26, 4:13 am, Tod <[email protected]> wrote:
> One of my project leader had similar requirement. The team manager
> want to know exactly real working time comparing with estimated time.
> That's maybe metric of team member's working efficiency.
>
> My solution:
> There is table named "ticket_change" in database make records of every
> ticket changes
>
> Real working hours = ticket closed time - ticket accept time - None
> working time
> Working time = from 9:00 am to 6:00 pm (exactly 9 hour including 1
> hour lunch time) from Monday to Friday
> None working time = from 18 pm to next day 9 am of working days, Sta,
> Sun, Holidays(Manual configure)
>
> Calculate the ticket working hours = Real Working hours(ticket closed
> time - ticket accept time)
>
> Excel Report
> Third part open source python component pyExcelerator
> format as below:
> || ticket id || ticket summary || owner || estimated time || real
> working time ||
>
> I have finished the code, and planed to write a simple web UI. If my
> solution can fit your requirement, I can share it to your team.
>
> Tod.
>
> On Aug 26, 10:47 am, bowikaxu <[email protected]> wrote:
>
> > Hi there, i am new to agilo but i already love it.
> > I am a team leader at a software factory and i used to do backlogs in
> > excel i want to start use agilo but i need to keep the time track for
> > every team member.
> > Every team member register day by day the work applied to a task and
> > at the end i compare my estimate with the real actual registered time
> > by the team member, the thing is that i dont know how to do this in
> > agilo.
>
> > Thanks in advance ... andres amaya diaz
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---
