Sorting of weeks in Event Report

Hi all,

I just ran an aggregate pivot table in the event report with weekly data, using relative period (last 12 weeks), and realised that it’s apparently impossible to sort the weeks in chronological order, Periods are sorted alphabetically, which results in week 1 being followed by weeks 10, 11, 12 in this case, rather than 2, 3 etc. (and no doubt 2 by 20, 21, 22, etc.). Same happens when manually selecting weeks as fixed periods.

image

Is there any workaround? If not, can the devs change weeks 1 to 9 to W01, W02,… W09 so that alphabetical sorting results in proper chronological order?

This is in v2.17

Thanks,

Bram Piot

PSI

Hi Bram,

this must be fixed. Will look at it.

···

On Mar 24, 2015 9:10 PM, “Bram Piot” bram.piot@gmail.com wrote:

Hi all,

I just ran an aggregate pivot table in the event report with weekly data, using relative period (last 12 weeks), and realised that it’s apparently impossible to sort the weeks in chronological order, Periods are sorted alphabetically, which results in week 1 being followed by weeks 10, 11, 12 in this case, rather than 2, 3 etc. (and no doubt 2 by 20, 21, 22, etc.). Same happens when manually selecting weeks as fixed periods.

Inline images 1

Is there any workaround? If not, can the devs change weeks 1 to 9 to W01, W02,… W09 so that alphabetical sorting results in proper chronological order?

This is in v2.17

Thanks,

Bram Piot

PSI


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Bram, this is now fixed in trunk, 2.18 and 2.17.

···

On Wed, Mar 25, 2015 at 7:32 AM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Hi Bram,

this must be fixed. Will look at it.

On Mar 24, 2015 9:10 PM, “Bram Piot” bram.piot@gmail.com wrote:

Hi all,

I just ran an aggregate pivot table in the event report with weekly data, using relative period (last 12 weeks), and realised that it’s apparently impossible to sort the weeks in chronological order, Periods are sorted alphabetically, which results in week 1 being followed by weeks 10, 11, 12 in this case, rather than 2, 3 etc. (and no doubt 2 by 20, 21, 22, etc.). Same happens when manually selecting weeks as fixed periods.

Is there any workaround? If not, can the devs change weeks 1 to 9 to W01, W02,… W09 so that alphabetical sorting results in proper chronological order?

This is in v2.17

Thanks,

Bram Piot

PSI


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp