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?
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?
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?
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:
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?
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:
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?