topic How do I get the average from this code? in QlikView

How do I get the average from this code?

Paknanarn23 — Fri, 15 Nov 2024 21:45:12 GMT

I want to find the total average from this code, how do I do that?

Re: How do I get the average from this code?

MayilVahanan — Wed, 15 Mar 2023 08:24:06 GMT

Might be, try like below

Avg(Aggr(urexp, urdimension))

Re: How do I get the average from this code?

Paknanarn23 — Wed, 15 Mar 2023 08:27:21 GMT

Hi
This is not what I want I want to find the AVg value. into this recipe

1-Count({<ST_Status = {'Failed'},MO_OrderType1 = {'ZM*1' ,'ZM*2'}>}DISTINCT MO_OrderNo)/(count({<MO_OrderType = {'ZM*1',' ZM*2'} , ST_Status = {'Completed'}>}DISTINCT MO_OrderNo)+ Count({<ST_Status = {'Failed'},MO_OrderType1 = {'ZM*1' ,'ZM*2'}>}DISTINCT MO_OrderNo ))