Creation of indicator based on Monthly data and aggregating to Quarterly with some logic for quarterly aggregation and a different one for geographical aggregation

Support - Assistance technique
4

Just for the Record, in case someone from the community lands here with the same need.

This was indeed not possible with the current implementation of predictors and indicators. Predictor couldn’t make it to use analytics, they relay on raw data, so cannot aggregate up, while indicators, even using subexpressions, where not doing the job either, as booleans were not being able to participate of aggregations (@Jim_Grace would have more details on it).

Thanks to @Scott and @Jim_Grace that drove all the process of identifying the problem and solution. Finally the way to implement these type of indicators, that will be available from 40.2 on, will be by using indicators with subexpressions, once they will work properly in 40.2. So in the end a single indicator like this…

Indicator type: Per cent
Numerator: subExpression(if(#{KwigVroDOBw}.aggregationType(SUM)==3,1,0))
Denominator: R{a0egEq3UhL1.EXPECTED_REPORTS}

…should do the job.

1 Like