Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
can you try this
=count( if(match(Col,'1','0'),'True','False') )
or
=sum( if(match(Col,'1','0'),'True','False') )
this doesn't work 😞
can you attach sample
from what
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