How to display text in the individual segments of a traffic light gauge chart

[#1]

Hi,

I have a requirement as below in a traffic gauge chart wherein i have to display the labels as below in the traffic light gauge chart :-

I'm not able to figure out how to do this , could you'll please help me.

Regards,

Rohan

[#2]

oopss !! it seems the diagrm hasn't come.

My traffic light gauge chart has 3 segments representing years of experience in a particular technology.

I have three technology viz. java , oracle, sas.

The traffic light gauge chart will show me the years of experience in these three technologies.

I want also to display the respective technology name in these three segments, not able to figure out how to do it.

Please help

[gauravkhare]

Hi Rohan,

Can you please mail me your sample data and i will make an application for you. Again the requirements you've mentioned Comprises of the three technologies for example java,.net etc...these tecnologies will be taken as dimension and we won't be including it in our gauge chart section..ok mail me your sample data...For expression also remember that we have to use a dividing factor.

[#4]

Hi Gaurav,

Thanks for your reply.

My data would be this way as shown below:-

I'm able to get the lights based on the years of experience but not able to get the technology name in these segments.

Please give me your email if possible so if the diagrams or data doesn't come here i can mail you the details.

Thanks for your help.

Name	Bi_Skill	From_year	To_year	Industry
Sanjay Gupta	BusinessObjects	2004	2007	Banking
Sanjay Gupta	Cognos	2007	2008	Telco
Sanjay Gupta	Cognos	2008	2009	FMCG
Sanjay Gupta	Qlikview	2009	2011	Insurance
John drew	BusinessObjects	2006	2008	Banking
John drew	BusinessObjects	2008	2009	Insurance
John drew	Qlikview	2009	2011	Retail Trade
Nancy lehman	Cognos	2007	2008	Insurance
Nancy lehman	Cognos	2008	2009	Telco
Nancy lehman	Cognos	2009	2011	Retail Trade
Daniel lopez	Qlikview	2005	2007	Banking
Daniel lopez	BusinessObjects	2007	2008	Telco
Daniel lopez	Cognos	2008	2011	Retail Trade
Ram Kumar	Cognos	2003	2006	Retail Trade
Ram Kumar	BusinessObjects	2006	2007	Telco
Ram Kumar	Qlikview	2007	2009	Banking
Ram Kumar	Qlikview	2009	2011	Insurance

[prieper]

If you donot have a caption activated, you cannot display help-text in the gauge-graph.
You can create a transparent textfield with text " ", write desired helptext (might also be calculated) into this textbox and place it over the gauge.

Result may look like the below, when hovering with the mouse over it:

HTH
Peter

edit:
Alternatively you may also create a second expression and choose display as text only

Peter

[gauravkhare]

gaurav.khare@teamcomputers.com

[#7]

Hi,