How to rename my Pie-Chart Values?

[#1]

I need to rename

D as Hold

B as Released

A as Shipped

Pls help !!

[amit_saini]

Hi ,

Use

load * Inline [

Sort_code , New_Sort_code

A , Shipped

B, Released,

D,Hold

];

and call New_Sort_Code in chart.

Thanks,

AS

[amit_saini · Accepted solution]

Second option is :

Wild-match Function

LOAD *

pick( WildMatch(Your_Field ,'*A*','*B*','*D*'),'Shipped','Released','Hold')

From

.....

Thanks,

AS

;

[#4]

Hi Amit,

You are Awesome man! thank you

[amit_saini]

Happy to help u buddy

Thanks,

AS

[#6]

hi amit.....can u plz tell me how to call a function (New_Sort_Code ) in chart

[amit_saini]

Kapil,

pick( WildMatch(Your_Field ,'*A*','*B*','*D*'),'Shipped','Released','Hold') as New_Sort_Code

You have to use this function within the same table of your field , later call this new field as expression in your chart.

Thanks,

AS

[prma7799]

Hi Amit,

I did pie chart like above but unable to show values on front of sort code.

Please help.

Thanks,

Prashant

[amit_saini]

Hi,

You need to call in expression as Count(New_Sort_Value)

Thanks,

AS

[#10]

Hi team,

See my Screen shorts.