Info about time spent on tasks in Timelog view or Table view
My problem: I'd like to get info about time spent on tasks by different users/tasks/days (for a longer date range). Right now the only proper way to do it is by exporting report from Timelog view and play with it in i.e. Excel. Which is definitely not optimal.
I see two possible solutions to achieve this in Wrike design (so there's no need to export data):
1) In Timelog view is all data I need, but there's a limit of 1000 rows, which forces me to export the data. Possible solution: show some aggregate data, depending on filter of course, but independently of 1000 rows limitation (sth similar to sums and averages in default Google Analytics reports)
2) In Table view we can select different date range (i.e. for tasks that are due for), but we're not able to select filter that would say that in this date range users spent so many hours doing different tasks. In advanced filters:
I'd expect option like: time spent on taks (in date range)
One advanced filter, which is close to what I want to achieve is 'last modified date', but it's still not correct. The problem here is that I can modify task (i.e. description) in February, but the last hours I entered/spent on this task is in January. If I select 'last modified date' filter and data range of February, this task would be in the report, which is wrong for me, because the last hours spent for this task were in January.
Even if I export data from table view, I of course have no appropriate data, because there's no proper filter I can use.
For now, I think I'm stuck with export of Timelog view and some Excel exercise. But I think that this fix wouldn't take much time and there're some other users which this fix would be very useful to.
Hi Boštjan, thanks for posting this on the Community! This is a really interesting filter request. Just to clarify: would you want a filter for selecting the amount of hours spent on a task, and a filter for the date range during which the time entry was added? Looking forward to hearing from you! Also, it looks like the image you inserted wasn't attached correctly - I'd love to see what was there. :)
Hi, thanks for reply. I'll try to explain by example:
What I'm suggesting, seems really simple to me, because it looks like it doesn't need any change in DB architecture, you'd just enable filtering by additional task fields (maybe there's another way to do it, but this is my idea):
- adding option sth. like "Task carried out/performed/conducted (you name it:)) date", which shows additional filter (similar to Date created, as in image)
- this additional filter would allow me to select date range (similar to Date created, as in image) - which would show just the filtered tasks, carried out in selected date range
Just to be clear: I don't need a filter for the date range during which the time entry was added, but I need a filter for the date range during which the task was carried out (entry timestamp can be very different from carried out period).
About a filter for selecting the amount of hours spent on a task you're asking about: don't need it and don't know exactly, what insight would I get out of it, but on the other hand, maybe someone find it useful. Again, it looks like it doesn't need any change in DB architecture, you'd just enable filtering by additional task fields, so the implementation shouldn't be too hard.
Hopefully the description is understandable;)
Regards, Boštjan
Boštjan, thanks for following up! This is really helpful, and I appreciate all of the details you included here. Thank you again for taking the time to share all of these ideas! :))
I had a similar issue, that I suppose can be solved the same way this need to be solved.
I'm trying to get weekly reports for every user, because I need to know how many hours that person work a week.
The issue is that if someone didn't add any hour, the dada did not appear in the time registry, and if I try to do something similar in the reports, I can obtain the people that didn't enter any data, but I cannot filter it for week.
So, in the reports it just would be useful a time filter, and in the time registry, an option to choose the users you want the data, even if their data has zero values.