Use alias in pie chart instead of number?

[jisephcirspy]

So, I have a column consisting of multiple numbers, and I want to make a pie chart which displays the numbers as their Strings like 'TWO' or 'FOUR' instead of 2 or 4.

This is how the pie chart looks like

Do you have any idea how to do that?

[Chanty4u]

can you try this

=count( if(match(Col,'1','0'),'True','False') )

or

=sum( if(match(Col,'1','0'),'True','False') )

[jisephcirspy]

this doesn't work 😞

[Chanty4u]

can you attach sample 

[jisephcirspy]

from what

[MayilVahanan]

HI @jisephcirspy 

Instead of front end, try like below

Load * inline

[

YourNumberField, StringFieldName

1, ONE

2, TWO

4, FOUR

];

Then in pie chart, use StringFieldName as Dim