Calculation in a Gauge Chart

[Anonymous]

Hi All,

I created a gauge chart wherin I'm trying to calculate the average leadtime of all the shipments to Beijing. However my formula does not work

Below is my formula:

Avg(Count(All{<Destination={BJS}>} TransitTime +1))

Suppose I want to express this in percentage, would the below formula work?

Avg(Count(All{<Destination={BJS}>} TransitTime +1)) / Count(Total TransitTime)

Thanks in advance!!!

iSam

[Anonymous]

Hi MartinPhol,

I’ve solved the problem J The problem was in the gauge settings and in the formula J.

I really appreciate all your help!!!

Cheers!

iSam