Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im trying to complete the table below, can anybody help with the changes to the DLWG 3 batch per rearer expression to make this table populate completely, and so I can show these values in a chart?
DLWG :
Avg({<[DLWG1]-={"0"},[DATE IN] = {"$(=Max([DATE IN]))"}>} aggr(rangeavg(above(Total Avg({<[DATE IN]=,[DLWG1]-={"0"}>}DLWG1),0,3)),[DATE IN]))
DLWG 3 batch:
Avg({<Rearer,[DLWG1]-={"0"},[DATE IN] = {"$(=Max([DATE IN]))"}>}Aggr(rangeavg(above(Total Avg({<Rearer,[DATE IN]=,[DLWG1]-={"0"}>}DLWG1),0,3)),[DATE IN],Rearer))
This should be the average of DLWG1 for the 3 most recent DATE IN per REARER
Some sample data attached
can u share the qvw or at least some rawdata?
Example of data attached, this is what I am trying to achieve
Thanks
see attached file
hope this helps
Thankyou !
Yes that works, the only problem is when there are less than 3 batches.
So is there a way I can change the /3 part on the end to divide by a count of the DATE IN up to 3 ( so if there are only two batches it will divide by two)
see attached qvw