For all function?

[#1]

Hi All QV'ers

I have a minor problem.I need to make a speedometer of an weighted avg. of some %. See attached file. Here i would like to show the weighted avg of the column called "Actual utilization %" wich is the "Targit m3"/"utilization of total. But if I use the formula from these two figures, then I only get 70 %, which is the figure for the height = 1200. So actually I need a function for ALL Heights, the sum of heights or something like that. The correct result should be 135.870/183.783 = 74 %

Help anyone

Best regards

Bjarne

[swuehl]

Hi BjarneQV,

so what are the expressions used in "Targit m3" and "utilization of total"?

And your dimension is just HEIGHT?

And what is the expression used in the gauge?

Maybe you could use something like

= sum(aggr( YOUREXPRESSION_TARGET_M3, HEIGHT)) / sum(aggr( YOUREXPRESSION_UTILIZATIONTOTAL, HEIGHT))

in your gauge, but maybe there is even a more simple solution.

Regards,

Stefan

[#3]

Hi Stefan

The expression for Targit m3 is (where 1200mm*800mm is a EUR pallet dimension and the height of the pallet is depending on the height of the location (therefore the IF's and we use of 50 % utilization, so therefore the height between 1200 and 1700 is 1450 and so on) and the pallet height is 144 mm, so have to subtract that). And finally we can not have more than 95% filling degree, so that is the *0,95 at the end

=1200*800*((If(HEIGHT=1200, 1008,if(HEIGHT=1700,1450,if(HEIGHT=2200,1950,2300))))-144)/1000000000*count(HEIGHT)*0.95

The expression for Utilization is

=count(HEIGHT)*0.95/count(TransportUnitID)*sum(AMOUNT*ITEMVOLUME/1000000000)

And I have tried the expression for the speedometer to be (the last one above/the first one above)

=(count(HEIGHT)*0.95/count(TransportUnitID)*sum(AMOUNT*ITEMVOLUME/1000000000))/(1200*800*((If(HEIGHT=1200, 1008,if(HEIGHT=1700,1450,if(HEIGHT=2200,1950,2300))))-144)/1000000000*count(HEIGHT)*0.95)

But the result of this is 70 % as it is for the height of 1200. So therefore it seems I'm missing for all.

And yes the dimension is only Height

I'll try the thing you suggest

Regards

Bjarne

[swuehl · Accepted solution]

Are you using a dimension in your gauge, too?

if yes, Try removing that dimension from the gauge chart, leaving dimension empty.

Stefan

[#5]

Hi

Yes know it works. TY

regards

Bjarne