Forum Discussion

Matthias93's avatar
Matthias93
Helper III
9 years ago
Solved

Changing text string to values

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 Agr...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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.

     

     

mtmcd's avatar
mtmcd
Frequent Visitor
9 years ago

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.