Problem with aggr

Remco — Tue, 16 Feb 2021 07:05:42 GMT

Hello,

I am trying to calculate the slope & intersect with the linest_m function that works ok but I am always struggling with the aggr. Now, in the table I want the calculation to be done one each gradient COUNTRYCODE and FUELTYPE. But now it does it over all. So, when I filter on a specific countrycode and fueltype, the calculation of linest_m is correct but how can I manage that the calculation takes place, without a filter placed, always between these dimensions?

The actual calculation is

linest_m(total aggr(avg(AVGPERF) ,STEP),log(STEP))

and I assume that somehow I have to add the 2 dimensions in here. I tried all kind of possibilities but without luck.

when filtered on a fueltype & countrycode, the correct amount is calculated for that section:

Thanks for your help

topic Problem with aggr in App Development

Problem with aggr