Disaggregation and Filtering of dates in Pivot-Tables

Dear all,

in our installation we store dataValues with a daily granularity. Now I want to
create a pivot table which displays all dataValues for all the days of the
current or last week or month. I want to do this only once with a relative
time-period filter (not by selecting the single dates every week).

So far I understand that the granularity of the dis-aggregation in a pivot table
is forcefully the same as the filter on the applied dimension. Since there is no
relative filter on days, I am afraid that this is not possible. I'd be happy if
someone could prove that I am wrong :slight_smile:

Thanks,

Uwe

Hi Uwe,

Currently, there is not a set of relative periods for “Last X days”, but it could of course be added.

Maybe you can file a blue-print?

Regards,

Jason

···

On Mon, Feb 8, 2016 at 1:28 PM, Uwe Wahser uwe@wahser.de wrote:

Dear all,

in our installation we store dataValues with a daily granularity. Now I want to

create a pivot table which displays all dataValues for all the days of the

current or last week or month. I want to do this only once with a relative

time-period filter (not by selecting the single dates every week).

So far I understand that the granularity of the dis-aggregation in a pivot table

is forcefully the same as the filter on the applied dimension. Since there is no

relative filter on days, I am afraid that this is not possible. I’d be happy if

someone could prove that I am wrong :slight_smile:

Thanks,

Uwe


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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Jason,

thanks Jason, that's what I was fearing. As a work-around I might just include
an additional date-category with a copy of the period, which I could then use
for disaggregation in the pivot table - well see.

I actually have a small list of potential blueprints - is there a specific
procedure to adhere to or do I just hack them into the registration form? Can I
add comments to existing blueprints?

Regards, Uwe

···

Jason Pickering <jason.p.pickering@gmail.com> hat am 8. Februar 2016 um 16:19
geschrieben:

Hi Uwe,

Currently, there is not a set of relative periods for "Last X days", but it
could of course be added.

Maybe you can file a blue-print?

Regards,
Jason

On Mon, Feb 8, 2016 at 1:28 PM, Uwe Wahser <uwe@wahser.de> wrote:

> Dear all,
>
> in our installation we store dataValues with a daily granularity. Now I
> want to
> create a pivot table which displays all dataValues for all the days of the
> current or last week or month. I want to do this only once with a relative
> time-period filter (not by selecting the single dates every week).
>
> So far I understand that the granularity of the dis-aggregation in a pivot
> table
> is forcefully the same as the filter on the applied dimension. Since there
> is no
> relative filter on days, I am afraid that this is not possible. I'd be
> happy if
> someone could prove that I am wrong :slight_smile:
>
> Thanks,
>
> Uwe
>
> _______________________________________________
> 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
>

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Uwe,

that sounds like a new set of relative periods (like Jason says). This makes sense and we are happy to add this.

Feel free to write a blueprint:

https://blueprints.launchpad.net/dhis2/+addspec

The process is generally that one first raises a problem or suggested feature on the mailing lists. If the dev team agrees it’s a sensible feature, you are free to write up a blueprint on Launchpad. This then gets assigned to a release. So - pretty much what you just did :wink:

regards,

Lars

···

On Mon, Feb 8, 2016 at 4:58 PM, Uwe Wahser uwe@wahser.de wrote:

Hi Jason,

thanks Jason, that’s what I was fearing. As a work-around I might just include

an additional date-category with a copy of the period, which I could then use

for disaggregation in the pivot table - well see.

I actually have a small list of potential blueprints - is there a specific

procedure to adhere to or do I just hack them into the registration form? Can I

add comments to existing blueprints?

Regards, Uwe

Jason Pickering jason.p.pickering@gmail.com hat am 8. Februar 2016 um 16:19

geschrieben:

Hi Uwe,

Currently, there is not a set of relative periods for “Last X days”, but it

could of course be added.

Maybe you can file a blue-print?

Regards,

Jason

On Mon, Feb 8, 2016 at 1:28 PM, Uwe Wahser uwe@wahser.de wrote:

Dear all,

in our installation we store dataValues with a daily granularity. Now I

want to

create a pivot table which displays all dataValues for all the days of the

current or last week or month. I want to do this only once with a relative

time-period filter (not by selecting the single dates every week).

So far I understand that the granularity of the dis-aggregation in a pivot

table

is forcefully the same as the filter on the applied dimension. Since there

is no

relative filter on days, I am afraid that this is not possible. I’d be

happy if

someone could prove that I am wrong :slight_smile:

Thanks,

Uwe


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

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org