Forum OpenACS Q&A: Response to Survey Package Expansion Proposal

create view survey_statistics_by_question
    select count(*) of entries grouped by question from
     survey_question_responses, as well as SUM
       of values as grouped by question

Create view survey_statistics_by_section
    select count(*) of entries grouped by section from the view
      survey_grading_sections_total, as well as the sum of all 
      the values per section

Create view survey_statistics
    select count(*) of entries grouped by survey from view
      survey_grading_total_score, as well as the sum of all the 
      values per survey

From these views it should be incredibly easy to create meaningful simple graphs. If you want to graph something more sophisticated you would need to do queries on existing tables...