Changing text string to values

[Matthias93]

Hi,

I'm trying to make a graph from SharePoint data. In these SharePoint data there are answers to certain questions that look like this: Strongly Disagree, Disagree, Neutral, Agree, Strongly Agree. For lay-out reasons I cannot change these answers to values within SharePoint. For my graph however I would like to be able to calculate average values to each question. So StronglyDisagree should equal 1, Disagree 2,... What function will let me do this?

Thank you in advance.

Kind regards,

Matthias

[mtmcd]

How would you plot those on a chart?  Say you want the parameters (Strongly Agree, Agree, Neutral, etc) on the Y-axis and the count on the X-axis.  How do you plot it such that the parameter names are used as the Y-axis labels?  I have a very similar problem in that my string values can't be used as axis labels.

[Matthias93]

Edit:

After pivoting my columns for the questions. My data now looks like this

[Vvelarde · Accepted solution]

hello @Matthias93

You can do it with a conditional column:

Go to Edit Query--Add Column - Conditional Column

Select each Value (Agree,Disagree, etc)  and put the Numeric Value that you assign.