deecay / redmine_pivot_table

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

Add weekly summary attributes to dates. #30

Closed deecay closed 7 years ago

deecay commented 7 years ago

This adds one extra attribute to date fields, an attribute for week number.

Week number is calculated according to Ruby's strftime("%U"). Which is:

Week number of the year, starting with the first Sunday as the first day of the first week.

Week number attribute is prefixed by %Y for proper sorting.

For the nature of pivottable.js, the "missing" week numbers cannot be filled or padded. If you do not have any data for, say Week24, then column "2016-W24" will not be shown in the pivot table. "2016-W25" will immediately follow "2016-W23".