Timecontrol - How to generate Total Hours Summary

[global.da]

How can i generate a graph summarizing the all assigned user total hours in a month?

what is being capture is the total of tickets per user not the total hours per user (image 1)

if i filter only one user, what is being captured is the qty of the hour e.g. 1hour - 9pcs, 2hours - 3pcs.(image2)

what i want is one assigned user , his total hours is one month. e.g user1 - 90hours, user2 - 50hours, user3 - 25hours etc..

thank you for your assistance

[joebordes]

sorry, but I don't understand. I would say that a normal report on Timecontrol module will give you the number and graph you are looking for.

you could have a look at the Timecontrol Totals module, that one was created to make it easier to generate reports

also, note that the number 838:59:59 is the maximum time limit of a MySQL time field

https://stackoverflow.com/questions/3925...9/39261014

so, that report is probably correct, but you have to many hours for MySQL

[global.da]

sorry, but I don't understand. I would say that a normal report on Timecontrol module will give you the number and graph you are looking for.

you could have a look at the Timecontrol Totals module, that one was created to make it easier to generate reports

also, note that the number 838:59:59 is the maximum time limit of a MySQL time field

https://stackoverflow.com/questions/3925...9/39261014

so, that report is probably correct, but you have to many hours for MySQL

i want to see each assigned users total time for a week or month and graph like this attached
but i cant produce this report

[global.da]

can someone assist

[joebordes]

Use metabase, this report will be easy to do there.

Have you tried with TCTotals?

[joebordes]

https://corebos.com/documentation/doku.p...tingtotals

https://github.com/tsolucio/tctotals

https://metabase.com/

[global.da]

https://corebos.com/documentation/doku.p...tingtotals

https://github.com/tsolucio/tctotals

https://metabase.com/

thank you joe
i will check this one