Aggregate Data Element--Needing it to be a Sum in 1 place, Max (sum in org unit) in another

Support - Assistance technique
1

Howdy team!

I’m trying to use an aggregate Data Element in two different ways in the same pivot table, and I’m having issues accomplishing it. The number is “Active People.” I’d like to have it be a “max (sum in org unit)” value as it stands alone, but also use a sum of the value for a denominator for an indicator looking at actions done per active people. I need both of these values to appear in the same pivot table.

I can set the number to (sum) in the Data Element, or (Max(sum in org unit)), but this only works for 1/2 of the values that I need. I can’t seem to override the sum or max aggregation within an indicator numerator/denominator.

  • I have tried periodOffset, however this is dependent on pivot table setup being broken down by individual periods, which is a dealbreaker.
  • I haven’t tried predictors–hoping that there is a simpler solution.
  • The KISS solution that I can think of would be to simply have entrants enter in the same value twice in the data Set: Active People and Active People (repeat). Then I can set one to Max, the other to Sum. Buttttttt I’m also hoping I don’t have to “admit defeat,” as this is what it feels like.

Anyone have thoughts? Thanks!!!

1 Like
2

Hi @Matthew_Boddie

Thanks for your patience. I’m wondering how you’ve approached this by now; however, here are somethings I was able to find out:

1 Like
3

@Gassim actually I was able to do this using predictors; I set a 1-1 relationship from the source DE to another “Duplicate” DE, and made one Sum while another Max (Org Unit Hierarchy Sum). This has worked quite smoothly!

Thanks to @Kris_Reinhardt for the previous post which helped get me there! Using multiple data element aggregation types

2 Likes