Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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(aggr(
avg(Duracion- (Aggr(Avg(duracionReal), F30_HRAsignada) + TiempoEspera)) /*Calculation of "diff" Column*/
, Duration))
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.
¿Any idea?
Best regards,
José María
Hi,
I finally fixed this problem in the Load Script. I calculated a new field that mark each continuos values with a ID.
The thread can be closed.
Thank very much!
Would you be able to share your application to play around with this? It is difficult to suggest anything without being able to see how the data structure looks like and without trial and erroring it
Hi,
I finally fixed this problem in the Load Script. I calculated a new field that mark each continuos values with a ID.
The thread can be closed.
Thank very much!