Calculated Average from Average

[#1]

Hi,

In the below formula I don't know what I am doing wrong.

=Avg(Avg(D2-D1) + Avg(D3-D2) + Avg(D4-D3))

I am using this formula in a expression for a speedometer chart to calculate the average no of days between D1 to D4.

Your help is very much appreciated.

Thanks!!

[rphpacheco]

QlikView does not accept average to average

[#3]

Then how can I achieve it? May be percentage would be good idea?

Please suggest.

[rphpacheco]

As these dates are formatted?

Could you post an example?

[#5]

Hello Pacheco,

I attched the qvw file above. I am usign the speedometer chart.

[rphpacheco]

You can average the average in this way:
= (avg (FinalDateVsPurchasedDate) + avg (OfferedDateVsVisitedDate) + avg (PurchasedDateVsOfferedDate)) / 3

The average of the table has to be 92.70.

See if that's right?!?!

[calvindk]

You can wrap it inside an aggregation as well, to do an avg(aggr(avg(D1to3),Dimensions))

Your dimensions for the aggr should be anything the user can select based on.

Edited for clarity using your expression:

Avg(Aggr(Avg(D2-D1) + Avg(D3-D2) + Avg(D4-D3)), Dimensions)

[rphpacheco]

I tried this way also Anders, but for the example that qvw SAARU sent did not work.

[jagan]

Hi,

Hi,

Try using RangeAve

=RangeAvg(Avg(D2-D1),  Avg(D3-D2),  Avg(D4-D3))

Hope this helps you.

Regards,

Jagan.