Replace dimension name in Bar chart

[NurulAin]

Hi, i have the following charts and need to change the dimension name "Not applicable" to "HUB" and "Papua New Guinea" to "PNG". Can someone show me how to go about this? 

Dimension used in this is "Market".

[Gysbert_Wassenaar]

You can use a calculated dimension in which you replace the values with other values using an if statement. But a better solution is to replace the values in the load script. Or create an extra field in the load script where you replace the values.

[NurulAin]

Hi Gysbert, could you share with me how to do the if statement or what to type in the script?

[Gysbert_Wassenaar]

LOAD
If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG',Market)) as Market,
...other fields...
FROM ...source....

[NurulAin]

I tried to follow this script, but when i reload there is an error message as in the picture. what did i do wrong?

LOAD

If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG')) as Market

From [C:\Users\nain\Digicel Caribbean Ltd\Performance Transformation Pacific - Documents\03 Reports\05 Tracker WAVE\00 Archive - Latest Data\Latest data - Wave - 20190113 (17h39m).xlsx];

[bvssudhakar]

Hi @Gysbert_Wassenaar

Can you please write it as calculated dimension also because i want to know how to write in calculated dimension in this type condition 

Thank you in advance

B V S Sudhakar

[bvssudhakar]

Hi @NurulAin

Can you please share your Script

[Gysbert_Wassenaar]

Replace 'Market' with the name of the field that contains the values you want to replace.

[bvssudhakar]

Hi @NurulAin

Sorry not script, Share your Excel file

[Gysbert_Wassenaar]

=If(Market = 'Not Applicable', 'HUB', If(Market = 'Papua New Guinea', 'PNG',Market))
And again use the real field name if it's not named Market.