Aggregation type for Tracker Data Elements

Hi,

We have program stage data elements of type integer for year and for month that show up as sums when visualizing in the pivot table. I see that going in to edit the Data Elements, that changing the Aggregation Type is disabled for Data Elements of type Tracker.

How can we change the aggregation type to be average, so the year and month will show up properly in the pivot table instead of summed?

Thanks,

Lorill

···

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

Hi!

Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

···

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

Hi Lorill,

I think this has been fixed, please try to upgrade to latest build of your stable version (which is it?).

regards,

Lars

···

On Thu, May 18, 2017 at 10:57 AM, Markus Bekken markus@dhis2.org wrote:

Hi!
Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

  1. mai 2017 kl. 20.44 skrev Lorill Crees lcrees@2paths.com:

Hi,

We have program stage data elements of type integer for year and for month that show up as sums when visualizing in the pivot table. I see that going in to edit the Data Elements, that changing the Aggregation Type is disabled for Data Elements of type Tracker.

How can we change the aggregation type to be average, so the year and month will show up properly in the pivot table instead of summed?

Thanks,

Lorill


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15


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


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi Lars and Markus,

Sorry, I forgot to include the version details:

Version:

2.24

Build revision:

89234f1

Build date:

2017-03-13 06:20

And yes, I am able to recreate on play.dhis2.org:

https://play.dhis2.org/release2/dhis-web-maintenance/#/edit/dataElementSection/dataElement/eMyVanycQSC?_k=ljbncw

Note that AggregationType says “None” and does not allow modification.

In the meantime I will try upgrading to the latest 2.24 build and try it out.

Thanks,

Lorill

···

On Thu, May 18, 2017 at 2:00 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

I think this has been fixed, please try to upgrade to latest build of your stable version (which is it?).

regards,

Lars

On Thu, May 18, 2017 at 10:57 AM, Markus Bekken markus@dhis2.org wrote:

Hi!
Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

  1. mai 2017 kl. 20.44 skrev Lorill Crees lcrees@2paths.com:

Hi,

We have program stage data elements of type integer for year and for month that show up as sums when visualizing in the pivot table. I see that going in to edit the Data Elements, that changing the Aggregation Type is disabled for Data Elements of type Tracker.

How can we change the aggregation type to be average, so the year and month will show up properly in the pivot table instead of summed?

Thanks,

Lorill


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15


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


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

Hi Lorill,

that is in fact not related to the domain type, rather we do not support aggregation of dates / data element of date value type, and so we disable the aggregation type selector.

regards,

Lars

···

On Thu, May 18, 2017 at 4:35 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars and Markus,

Sorry, I forgot to include the version details:

Version:

2.24

Build revision:

89234f1

Build date:

2017-03-13 06:20

And yes, I am able to recreate on play.dhis2.org:

https://play.dhis2.org/release2/dhis-web-maintenance/#/edit/dataElementSection/dataElement/eMyVanycQSC?_k=ljbncw

Note that AggregationType says “None” and does not allow modification.

In the meantime I will try upgrading to the latest 2.24 build and try it out.

Thanks,

Lorill

On Thu, May 18, 2017 at 2:00 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

I think this has been fixed, please try to upgrade to latest build of your stable version (which is it?).

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Thu, May 18, 2017 at 10:57 AM, Markus Bekken markus@dhis2.org wrote:

Hi!
Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

  1. mai 2017 kl. 20.44 skrev Lorill Crees lcrees@2paths.com:

Hi,

We have program stage data elements of type integer for year and for month that show up as sums when visualizing in the pivot table. I see that going in to edit the Data Elements, that changing the Aggregation Type is disabled for Data Elements of type Tracker.

How can we change the aggregation type to be average, so the year and month will show up properly in the pivot table instead of summed?

Thanks,

Lorill


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15


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


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi Lars,

Oops, I guess I picked a bad example. The one in our system is a number, not a date. Here is another example that is not a date on play.dhis2.org:

https://play.dhis2.org/release2/dhis-web-maintenance/#/edit/dataElementSection/dataElement/qrur9Dvnyt5?_k=hytru7

Thanks,

Lorill

···

On Thu, May 18, 2017 at 7:39 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

that is in fact not related to the domain type, rather we do not support aggregation of dates / data element of date value type, and so we disable the aggregation type selector.

regards,

Lars

On Thu, May 18, 2017 at 4:35 PM, Lorill Crees lcrees@2paths.com wrote:

Hi Lars and Markus,

Sorry, I forgot to include the version details:

Version:

2.24

Build revision:

89234f1

Build date:

2017-03-13 06:20

And yes, I am able to recreate on play.dhis2.org:

https://play.dhis2.org/release2/dhis-web-maintenance/#/edit/dataElementSection/dataElement/eMyVanycQSC?_k=ljbncw

Note that AggregationType says “None” and does not allow modification.

In the meantime I will try upgrading to the latest 2.24 build and try it out.

Thanks,

Lorill


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Thu, May 18, 2017 at 2:00 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Lorill,

I think this has been fixed, please try to upgrade to latest build of your stable version (which is it?).

regards,

Lars


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15

On Thu, May 18, 2017 at 10:57 AM, Markus Bekken markus@dhis2.org wrote:

Hi!
Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

  1. mai 2017 kl. 20.44 skrev Lorill Crees lcrees@2paths.com:

Hi,

We have program stage data elements of type integer for year and for month that show up as sums when visualizing in the pivot table. I see that going in to edit the Data Elements, that changing the Aggregation Type is disabled for Data Elements of type Tracker.

How can we change the aggregation type to be average, so the year and month will show up properly in the pivot table instead of summed?

Thanks,

Lorill


Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15


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


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd.

lcrees@2paths.com
skype: lorill2paths

(604) 689-4123 x 15