workload XLS export
under review
Vidas
under review
Vidas
planned
Vidas
Francois Chapelle are you interested in getting a graphical presentation of workload, just in xlsx format, or are you interested getting the data so that you can do your own analysis/math on top? The second, data only, option is far more viable and doable IMO.
F
Francois Chapelle
Vidas: definitly it's more about having the data in excel to do extra analysis.
Vidas
Francois Chapelle: great, then we just need to align on the actual data to be exported.
I can start with a proposal to export the following structure:
Item ID, Item Title, Start date, Due date, Assignee(s), Tag(s), EstimatedHours, Board ID, Row ID
We would offer .csv export for this case.
F
Francois Chapelle
Vidas: I would have prefered something that maps the Workload report, but just with numbers (see attached)
CSV would be perfect
Vidas
Francois Chapelle: as per your example it is a two dimentional structure, that definitely requires something more human readable like XLSX format.
With .csv we would focus mainly on plain data, formatting/presentation of that data would be totally on you.
Based on your example I already see that we have more ways to structure the data.
Option A - less data rows, one data row per item (as in workload itself) and it tells when item starts/ends, how many hours estimated, which user(s) assigned.
Option B - more data rows, one data row per user per item with start/due dates and estimation
Option C - even more data rows, one data row per user per item per date. User, item, date, hours for that date.
F
Francois Chapelle
Vidas: Hi Vidas
I would defintively prefer option C as it allows to generate a pivot table in excel.
Column would be :
User - project - Task - Date - Workload
NB : the users fchapelle@gmail.com and francois.chapelle@chanel.com belongs to me. I'm part of CHANEL IT
That feature is a very high priority for us. Please let me know if there is a way to prioritize that feature ?
Regards
Vidas
Francois Chapelle: we have a refinement next week, I will bring this one in and see what can be done. Everything will depend on the scope. Will inform you once I have a decission in our product team.
Vidas
Francois Chapelle: two more questions:
- What is a project in your case? Board?
- We will not export all the data (which means infinite future). Hence we need to limit how far into the future we take data. My proposal is to take from today + 4 next periods based on zoom level (day, week, month, quarter). Maybe for days it can be more, like +20 days.
F
Francois Chapelle
Vidas: Hello Vidas
Yes a project = a board for us
About the limit, we always plan for the 6 coming months (whatever the zoom level).
I understand it's more costly in terms of CPU / ressources. Maybe you could offer the option to export until a custom date but no more than 6 months from the current date ?
Vidas
Francois Chapelle: Thank you. I have documented this request and placed it among other customer requests. That means we will do it. But, I cannot tell what is the ETA at least for now, since there is a fine list of other requests already in the line. Where higher upvote numbers or paid subscription plan influences that priority in the queue.
F
Francois Chapelle
Vidas: Ok clear. Note that I'll also have a paid subscription as soon as the trail period ends.