Calculate Min Expression

Anonymous — Tue, 16 Sep 2014 05:53:57 GMT

Hi All,

I have a calculated price per ton in my chart.

i wish to use the minimum price in a different chart and show the price i would have paid if i took the lowest price.

so far i couldn't get the minimum price so i can use it in a gauge chart for instance.

thanks for any help

Avner

Re: Calculate Min Expression

marcus_sommer — Tue, 16 Sep 2014 06:32:01 GMT

Try something like this:

avg(aggr(Price/Ton), [Pack Type]))

Maybe you need further dimensions within your expression.

- Marcus