Indicators totaling to average rather than sum in pivot tables?

Hi all, I put in a ticket on Jira but am wondering if others have experienced an issue in 2.29 where pivot tables run with indicators provide an average of all values in the total column, rather than a sum of the values?

The table options are correctly set, as are the aggregation options for the data elements that make up the indicator.

We recently upgraded and this seems to have come with the upgrade.

Thanks,

Karen

image

1 Like

Hi Karen,

Yes this is new feature of 2.28 which unfortunately does not work for sum indicators where you would like to sum up raw data values. There is already a Jira issue for it here You can vote for it.

Regards

image

···

Elmarie Claasen

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp.org@lists.launchpad.net] On Behalf Of Karen Levin
Sent: Friday, June 29, 2018 2:24 AM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

Hi all, I put in a ticket on Jira but am wondering if others have experienced an issue in 2.29 where pivot tables run with indicators provide an average of all values in the total column, rather than a sum of the values?

The table options are correctly set, as are the aggregation options for the data elements that make up the indicator.

We recently upgraded and this seems to have come with the upgrade.

Thanks,

Karen

Dear Elmarie,

Has this issue been resolved?

I am also experiencing the same thing.

Stanley

image

···

On Fri, Jun 29, 2018 at 8:13 AM Elmarie Claasen elmarie@hisp.org wrote:

Hi Karen,

Yes this is new feature of 2.28 which unfortunately does not work for sum indicators where you would like to sum up raw data values. There is already a Jira issue for it here You can vote for it.

Regards

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp.org@lists.launchpad.net] On Behalf Of Karen Levin
Sent: Friday, June 29, 2018 2:24 AM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

Hi all, I put in a ticket on Jira but am wondering if others have experienced an issue in 2.29 where pivot tables run with indicators provide an average of all values in the total column, rather than a sum of the values?

The table options are correctly set, as are the aggregation options for the data elements that make up the indicator.

We recently upgraded and this seems to have come with the upgrade.

Thanks,

Karen

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.


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

Hi Stanley,

No, it has not been resolved. The initial bug reports was turned into a new feature DHIS2-2380 which is still pending.

Regards,

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

···

Dear Elmarie,

Has this issue been resolved?

I am also experiencing the same thing.

Stanley

On Fri, Jun 29, 2018 at 8:13 AM Elmarie Claasen elmarie@hisp.org wrote:

Hi Karen,

Yes this is new feature of 2.28 which unfortunately does not work for sum indicators where you would like to sum up raw data values. There is already a Jira issue for it here You can vote for it.

Regards

Elmarie Claasen

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp.org@lists.launchpad.net] On Behalf Of Karen Levin
Sent: Friday, June 29, 2018 2:24 AM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

Hi all, I put in a ticket on Jira but am wondering if others have experienced an issue in 2.29 where pivot tables run with indicators provide an average of all values in the total column, rather than a sum of the values?

The table options are correctly set, as are the aggregation options for the data elements that make up the indicator.

We recently upgraded and this seems to have come with the upgrade.

Thanks,

Karen

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.


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

Hi Karen/Elmarie,

Just wanted to let you know that we take this problem very seriously and that good progress is currently being made towards a proper solution for this.

Jan

image

···

On Wed, Oct 3, 2018 at 8:56 AM Elmarie Claasen elmarie@hisp.org wrote:

Hi Stanley,

No, it has not been resolved. The initial bug reports was turned into a new feature DHIS2-2380 which is still pending.

Regards,

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Stanley Kalyati skalyati@gmail.com
Sent: Wednesday, October 3, 2018 7:47 AM
To: Elmarie Claasen elmarie@hisp.org
Cc: Klevin@engenderhealth.org; DHIS Users dhis2-users@lists.launchpad.net; DHIS 2 Developers list dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

Dear Elmarie,

Has this issue been resolved?

I am also experiencing the same thing.

Stanley

On Fri, Jun 29, 2018 at 8:13 AM Elmarie Claasen elmarie@hisp.org wrote:

Hi Karen,

Yes this is new feature of 2.28 which unfortunately does not work for sum indicators where you would like to sum up raw data values. There is already a Jira issue for it here You can vote for it.

Regards

Elmarie Claasen

Project Manager

Health Information Systems Program

Tel: 041-367 1027

Cell: 082 374 2209

E-mail: elmarie@hisp.org

Skype: elmarie.claasen52

From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp.org@lists.launchpad.net] On Behalf Of Karen Levin
Sent: Friday, June 29, 2018 2:24 AM
To: dhis2-users@lists.launchpad.net
Subject: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

Hi all, I put in a ticket on Jira but am wondering if others have experienced an issue in 2.29 where pivot tables run with indicators provide an average of all values in the total column, rather than a sum of the values?

The table options are correctly set, as are the aggregation options for the data elements that make up the indicator.

We recently upgraded and this seems to have come with the upgrade.

Thanks,

Karen

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.


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

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.


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

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

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

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

2 Likes

A post was split to a new topic: Indicators totaling to average rather than sum in pivot tables?