How to create a pie chart based on alpha numeric values ?

[#1]

i am sharing the source data column and expected pie chart, any idea how to create it ?

thanks.

[MK_QSL]

Dimension

YourFIeldName

Expression

Count(YourFieldName)/Count(Total YourFieldName)

[hariprasadqv]

Hi,

Devide the data into two coulmns and use as source so that you get Right one.

[sunny_talwar]

You can use a dual function in your script which will assign satisfaction with a numeric as well as alpha-numeric value.

So something like this:

Pick(Match(Satisfaction, 'Very satisfied', 'Satisfied', 'Neutral', 'Dissatisfied', 'Very dissatisfied'), Dual(Satisfaction, 5), Dual(Satisfaction, 4), Dual(Satisfaction, 3), Dual(Satisfaction, 2), Dual(Satisfaction, 1)) as SatisfactionDual

[#5]

Hi @MRKachhiaIMP,

i think it worked, but i didnt get it exactly, can you please elaborate the expression a little ?

[#6]

and how to calculate and display the percentage

[hariprasadqv]

Use Relative property in Expression.

[#8]

nope, its not working

[hariprasadqv]

Your data consisting of 3 diffrent values. Consider them as dimension values.

Assue Total number of values as 20.

In that 6 as 5.Very satisfied -> (6/20)*100

In that 6 as 4.Satisfied -> (6/20)*100

In that 8 as 5.Neutral -> (8/20)*100

[MK_QSL]

I thought you want to know how many times

1.Very Dissatisfied

2. Dissatisfied etc is coming...

Considering that your field name is [Overall satisfaction of facilities and services] you can get the desired result by

COUNT([Overall satisfaction of facilities and services])/COUNT(TOTAL [Overall satisfaction of facilities and services])

Go to Number tab and select Fixed To 2 Decimal and Tick Show in Percent (%)

COUNT(FieldName) will give you count of individual values (i.e. how many times 1.Very Dissatisfied is appearing and so on)

COUNT(Total FieldName) will give you total values for this fieldname