Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You may use Earnings/Expenses or (Earinings - Expenses) as value.
You can assign minimum value of segments accordingly.
Hope this helps.
Hey Meher,
Here's one way of doing it. You can change the values in the input box for testing.
Hi Krishnamoorthy ,
thats a nice idea but it won't works for me because i cant assign values for segments ...
thanks
meher
Thanks Johannes
May be it works & i think i can use predefined values instead of giving values thru input box ...
thanks a lot
Meher
Sure, the input box is merely for testing and showing that it works. Otherwise you can use Sum(Expenses) etc. instead.
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
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..
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
Oh, ok. In that case please send in a copy of the document if you can't figure it out.