4 Replies Latest reply: Sep 21, 2012 4:09 AM by Robin Warrilow

Max limits in gauge trellis charts

Hi,

I've set up a trellis chart of 3 gauges, one for each department and I need to show how each is performing against the Sum(Budgets) for each separate department.

How can I effectively have a different max value generated for each department?

Hope this makes sense.

Robin

• Re: Max limits in gauge trellis charts

Try having an If..Then statement in the max value field.

If(department='A', 3,

If(department='B',4,

If(department='C',5')))

• Re: Max limits in gauge trellis charts

in max Value

Sum(Budgets)* 1.2( taking 20% extra of sum)

hope this helps

• Re: Max limits in gauge trellis charts

Thanks Sunil and Josh, but this won't work for me because the Sum(Budgets) gives me the combined total for every department (i.e. the entire company) whereas I need the each gauge to recognise which dimension (department) it relates to and then only calculate its max value as the budget for that single department.

Sorry if I didn't make this clear in the original post.

• Re: Max limits in gauge trellis charts

Sorted.

I just changed my expression to show the percentage of budget met and this has worked OK.