search

deecay / redmine_pivot_table

This Redmine plugin allows you to generate pivot table for issue analysis.
MIT License
52 stars 38 forks source link

Task tab date fields YMD split #29

Open Niremizov opened 7 years ago

Niremizov commented 7 years ago

Task tab does not have date fields splitted into Year, Month, Day groups - but Activities does have, why so? Can Task tab also imlement such feature?

deecay commented 7 years ago

The reason is that Task has many columns with dates and times, and if I split all these fields into datetime components such as YYYY, MM, DD, HH24, mm, etc, there will be too much items in the attribute lists.

Currently I do not have any idea how to build a manageable and simple UI for showing split dates and times.

Niremizov commented 7 years ago

I see. Well, probably one of possible solutions would be:

Use of default query options where you can choose what exactly columns should be accessed by Pivot. After default columns were selected user could choose row/column output inside PivotTable. In that case date field can be derrived with y-m-d style https://yadi.sk/i/wVSo1UQXymm8u.