Show all values in gauge chart, even if 0

[#1]

Hi,

I have 3 gauge chart, which show a risk percentage next to each student.

It shows all students which have a risk, ie. anything greater than 0, but excludes/doesn't show the 0% values(Students)

I'd also like to show these, even if there Risk is 0%.

I'm not sure what I can do to the expression to change this.

Any ideas?

Thanks!

[johnw · Accepted solution]

I'd have thought this would be easy - don't suppress zeros, but do suppress missing.  That doesn't work.  So here's a kluge.  Change the expression for Risk to this:

if(Column(1)=0,.00001,column(1))

Since it isn't 0, suppressing 0 won't suppress it, but it will display as 0.

Hopefully I'm just missing a cleaner way to do it.

[swuehl]

Hi beanz,

another idea:

I think the problem is the second dimension, which gets only limited by the set expression in the gauge calculation.

I noticed then that the system dimension is fixed for a table and also redundant, since already part of the table name.

So I have two possible alternatives to John's workaround:

1) remove the second dimension, select supress zeros from dimension tab and deselect supress zeros from presentation tab. This way you're table real estate is smaller. If you need the system information explicitely for each row, you might add a fixed expression "System" with appropriate value again.

I applied alternative 1 to gauge table 1.

2) limit the system dimension and remove the set expression from the gauge calculation.

Select supress zeros for second dimension and deselect supress zeros from presentation tab.

I applied alternative 2 to gauge table 2.

Regards,

Stefan

[#4]

Thanks John!

Works like a charm.