simple introduction and screen-shot. http://todaydream.com/2009/08/27/simple-ticket-report-plugin-for-trac-agilo-plugin/
On Aug 26, 10:19 pm, bowikaxu <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
