I have a graph table and I need calculate a column on a special way: the values are the average of the values of a previous column called (Diff) grouped by the continuous values of other column (Duration), See an example at the image below:
Currently I am calculating the "Avg. diff" column with this expression:
avg(Duracion- (Aggr(Avg(duracionReal), F30_HRAsignada) + TiempoEspera)) /*Calculation of "diff" Column*/
The result is this but it is not the expected result
I tried it using a calculated dimesion but calculated dimesion are not valied in AGGR functions.