4 Replies Latest reply on Sep 20, 2018 9:31 AM by meenu choudhary

    How can I make a barchart of survey results

    Chris Keeney

      I have a .csv file of survey results. 6 of the questions have values "High Improvement", "Moderate Improvement", "No Improvement"

       

      I want to make a bar chart where there is a section per question and a bar for each type of improvement.

       

      I thought I could add each question to the columns section, but it makes it tiered.

       

      Do I have to make a calculated field for each question?

       

      Below is an example of how the data looks:

       

         

      Q1Q2Q3Q4Q5
      High ImprovementHigh ImprovementModerate ImprovementModerate ImprovementModerate Improvement
      High ImprovementHigh ImprovementHigh ImprovementHigh ImprovementHigh Improvement
      No ImprovementHigh ImprovementHigh ImprovementHigh ImprovementHigh Improvement
      Moderate ImprovementModerate ImprovementHigh ImprovementHigh ImprovementHigh Improvement
      High ImprovementNo ImprovementNo ImprovementModerate ImprovementModerate Improvement
      No ImprovementNo ImprovementNo ImprovementNo ImprovementNo Improvement

       

      Added Data example