topic Re: Compare to average in App Development

Compare to average

dtbit123 — Sat, 29 Jan 2022 21:51:41 GMT

To explain my question

Ill write in a wrong

Way and please correct me.

Avg(if(day_ssupplied

< avg(day_ssupplied),

day_ssupplied))

I want to used that

Expression as master item

So the inner avg should be flexible to any dimension it will stand with.

I tried aggr but it's not flexible with dimension.

Thank

Re: Compare to average

Vegar — Sat, 29 Jan 2022 22:29:50 GMT

You could try to use aggr(), but instead of aggregating on a fixed dimension you can fetch it dynamically based on which alternative dimension you are using.

I think the correct function to use is GetObjectField() or GetObjectDimension() . Like this.

Aggr(avg(...), [$(=GetObjectField(0))])