Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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