How do I rename field values?

[Anonymous]

I have a field called 'group' and it has 6 possible values - '1. Under 10hr', '2. Under 40hr', '3. under 80h', '4. Under 160', '5. Under 320', '6. Over 320'.   

The possible values aren't very clear.  I would like to present these differently in all my charts and tables.  I would like to rename them to - 'Under 10 hours', '10 up to 40 hours', '40 up to 80 hours', '80 up to 160 hours', '160 up to 320 hours', '320 hours up to FT'.

Is there a way to do this in the 'edit script'.?

Thanks

Greg

[AshwinDaniel]

Dear @rwunderlich ,

Thank you for your assistance.

I would like to change the background color too based on the output. Is that possible using any chart?

Currently I am using "Text and Image"

Regards,

Ashwin Daniel

[AshwinDaniel]

Thank you for your assistance @rwunderlich ,  I played wrong with the single and double quotes. 

Many thanks,

[AshwinDaniel]

Dear @rwunderlich ,

Could you please suggest me, which chart to use:

I would like to change the background color as RED when it is not eligible and GREEN on Eligible.

Many thanks in advance. 

[rwunderlich]

You should start a new thread for these new questions.  It's difficult to get answers when new questions are added to old posts. 

-Rob

[AshwinDaniel]

Yes you are right @rwunderlich. I shall open this as a new thread Mr. Rob.

Regards,