9 Replies Latest reply: Jun 13, 2011 7:25 PM by Johannes Sunden

guage charts

Hello Experts

I have a query to clarify regarding mini guage charts

my requirement is to make a personal chart on my expenses and earning ...

I'm trying to use a traffic guage and if my expenses are greater than earnings my guage have to turn into red

if my expenses are equal to earnings my guage have to turn into blue and

if my expenses are less than earnings my guage have to turn into green

is this possible ??? itried it but in segments it asks for a value then ow can i do it ???

example my data is like this

expenses         earnings          guage color

30,750             25,687              red

18,600             18,600              blue

22,600             30,920              green

is there any way to do it ???

thanks to u all

Meher

• guage charts

You may use Earnings/Expenses  or (Earinings - Expenses) as value.

You can assign minimum value of segments accordingly.

Hope this helps.

• guage charts

Hi Krishnamoorthy ,

thats a nice idea but it won't works for me because i cant assign values for segments ...

thanks

meher

• Re: guage charts

Hey Meher,

Here's one way of doing it. You can change the values in the input box for testing.

• guage charts

Thanks Johannes

May be it works & i think i can use predefined values instead of giving values thru input box ...

thanks a lot

Meher

• guage charts

Sure, the input box is merely for testing and showing that it works. Otherwise you can use Sum(Expenses) etc. instead.

• guage charts

Hi Johannes

I tried to make it work as a mini chart but it fail's.

I'm trying to compare budget vs sales but its not working perfectly for me I mean the guage is changing colors between only orange & Green & its showing both Orange & Green for Sales<< budget....

I’m using this expression

If((Sales2009<<Budget2009),(if(Sales2009=Budget2009,-1,0)),1)

And in gauge settings I’m using -1 & 1 as min & max values of gauge and trying for 3 segments  as -1to0 for  Red , 0 for Orange & 0.1 to 1 for green

Any idea to sort this out

thanks

Meher

• guage charts

Hi Meher,

You might want to try using Sum(Sales2009) etc. instead of just the fieldnames since I assume that you have more than one value for each of the fields.

If((Sum(Sales2009)<=Sum(Budget2009)),(if(Sum(Sales2009)=Sum(Budget2009),0,-1)),1)

something like that..

• guage charts

hi Johannes ,

i need it for each & every row in a mini chart i'll try it and i'll let you know

thanks a lot

meher

• guage charts

Oh, ok. In that case please send in a copy of the document if you can't figure it out.