Convert strings to numbers

DataGraph Forums › Technical Support › Support Desk › Convert strings to numbers

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #15588
    todd franke
    Participant

      I often create graphs with responses that are Likert scale questions (string). On occasion, I need to convert these to numbers because I want to show the mean response to a given question or set of questions. I am clearly using the wrong search words. Can anyone point me to a response that addresses this question? Thank you.

      #15589
      kirkt
      Participant

        See if this is what you are looking to do.

        Kirk

         

        Screenshot 2025-05-06 at 12.15.38 PM

        #15590
        todd franke
        Participant

          Thank you Kirk.  The data are words like Strongly agree,  Disagree based on the respondents response.  How do I assign the numbers so for example every Strongly disagree becomes a 1 — and Strongly agree becoming a 5 with 2, 3, 4 assigned to the other choices? They are only ordered based on how the participant responded.

          #15596
          kirkt
          Participant

            You can try a Map column.  See screenshot and read about Map columns in the User Manual.

            Kirk

            Screenshot 2025-05-06 at 2.17.31 PM

            #15620
            dgteam
            Moderator

              Agree! The Map column should help you with this.

              kirkt’s example shows nicely how you can use the Map column to go from Text to Number. Another option is to use a look-up table.

              We just added an additional example in the on-line documentation to help explain further: See Map Column.

               

            Viewing 5 posts - 1 through 5 (of 5 total)
            • You must be logged in to reply to this topic.

            DataGraph Forums › Technical Support › Support Desk › Convert strings to numbers