+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Modules/Extension Support (https://discussions.corebos.org/forumdisplay.php?fid=9)
+--- Thread: Timecontrol - How to generate Total Hours Summary (/showthread.php?tid=1984)
Timecontrol - How to generate Total Hours Summary - global.da - 10-21-2020
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
RE: Timecontrol - How to generate Total Hours Summary - joebordes - 10-21-2020
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/39259910/why-is-mysqls-maximum-time-limit-8385959/39261014
so, that report is probably correct, but you have to many hours for MySQL
RE: Timecontrol - How to generate Total Hours Summary - global.da - 10-22-2020
(10-21-2020, 11:03 PM)joebordes Wrote: 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/39259910/why-is-mysqls-maximum-time-limit-8385959/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
RE: Timecontrol - How to generate Total Hours Summary - global.da - 10-26-2020
can someone assist
RE: Timecontrol - How to generate Total Hours Summary - joebordes - 10-28-2020
Use metabase, this report will be easy to do there.
Have you tried with TCTotals?
RE: Timecontrol - How to generate Total Hours Summary - joebordes - 10-28-2020
https://corebos.com/documentation/doku.php?id=en:extensions:extensions:timecontrol#reportingtotals
https://github.com/tsolucio/tctotals
https://metabase.com/
RE: Timecontrol - How to generate Total Hours Summary - global.da - 11-02-2020
(10-28-2020, 12:56 AM)joebordes Wrote: https://corebos.com/documentation/doku.php?id=en:extensions:extensions:timecontrol#reportingtotals
https://github.com/tsolucio/tctotals
https://metabase.com/
thank you joe
i will check this one