How to change values on axis of chart?

[rittermd]

I have created a chart and it currently displays the actual value for the field which is a letter.  I want a more descriptive value instead.

For example.  Right now it displays the letter A.  I want it to say Appointment instead.

I can't figure out where I would do this.

[jaimeaguilar]

Hi,

in dimensions tab > edit > you can edit directly in the graphic the description for each dimension item,

for example, type:

pick(match(FieldName, 'A'),'Appointment')

This function will look for value A in your field and replace it with "appointment".

btw, you can also do this at script level,

regards

[rittermd]

Thanks.

How would I code this statement to handle 3 different scenarios?

B=Both

L=Living

W=Last

M=Missing

[jaimeaguilar]

You can still use the same pick/match syntax and change as many strings as you want:

pick(match(fieldName, 'B','L','W','M'), 'Both','Living','Last','Missing')

Also is important to note that sometimes is better to use Wildmatch() instead of Match(), because it lets you use wildcards (like searching substrings) and search strings regardless of caps (eg. A, a, B, b).

[rittermd]

Thank you very much. That worked.

[jaimeaguilar]

Hi,

Could you please mark a answer as helpful or correct if it helped you to solve your issue? Also it is important, so other persons with a similar trouble can get to an answer,

Thanks

[rittermd]

Only one issue with your response.  You left off the right side ' on the last value.  So I had to add that and then it worked fine.