Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Average number of contact hours per student

    Hello I am trying to find out the the Average number of contact hours per student. in Reporting Services 2005. The contact hours is the in the Totaltime field

    Is this formula correct

    =Sum(Fields!TotalTime.Value)/Avg(Fields!TotalTime.Value) is in the =Fields!StateServices.Value Group


    My groups are


    =Fields!Student_ID.Value


    =Fields!StateCategory.Value


    =Fields!StateServices.Value
    Code:
    SELECT     Student_ind.[Student ID], ParticipantActivity.ActivityDate, School_tbl.[Studentschool Id], School_tbl.schoolID, ParticipantActivity.TotalTime, 
                          ParticipantActivity.Services, ParticipantActivity.Activity, Student_ind.SSID, ParticipantActivity.StateCategory, ParticipantActivity.StateServices
    FROM         ParticipantActivity INNER JOIN
                          School_tbl INNER JOIN
                          Student_ind ON School_tbl.[Student ID] = Student_ind.[Student ID] ON ParticipantActivity.[Student ID] = Student_ind.[Student ID]
    WHERE     (ParticipantActivity.StateCategory IN (N'Academic Support', N'Self Concept', N'Counseling')) AND (ParticipantActivity.ActivityDate BETWEEN 
                          @Beginning_ActivityDate AND @End_ActivityDate)
    ORDER BY ParticipantActivity.ActivityDate, CASE WHEN ParticipantActivity.[StateCategory] = N'Academic Support' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'In-Class Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'One-on-One Tutoring Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Small Group (up to 3) Tutoring Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Large Group Tutoring Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Self Directed - Academic Service' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateCategory] = N'Self Concept' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Cultural Activities Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Youth Leadership Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateCategory] = N'Counseling' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Individual Personal Adjustment Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Individual Academic Progress Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Individual Vocational Planning Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Group Personal Adjustment Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Group Academic Progress Hours' THEN 0 ELSE 1 END, 
                          CASE WHEN ParticipantActivity.[StateServices] = N'Group Vocational Planning Hours' THEN 0 ELSE 1 END

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    To find the average number of contact hours per student, I would use:
    Code:
    Avg(Fields!TotalTime.Value)
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by Pat Phelan View Post
    To find the average number of contact hours per student, I would use:
    Code:
    Avg(Fields!TotalTime.Value)
    -PatP
    PAT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! How are you doing???
    How was your New Years??

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by Pat Phelan View Post
    To find the average number of contact hours per student, I would use:
    Code:
    Avg(Fields!TotalTime.Value)
    -PatP
    Should I put that in a group or no??

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by Pat Phelan View Post
    To find the average number of contact hours per student, I would use:
    Code:
    Avg(Fields!TotalTime.Value)
    -PatP
    I put =Sum(Fields!TotalTime.Value)/Count(Fields!Student_ID.value)

    and got 1.55 on the footer of the report
    =Avg(Fields!TotalTime.Value) works too cool
    Last edited by desireemm; 02-20-12 at 20:03.

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    I cant seem to get the correct total average theres a total of 106 students with a total 3335 hours answer I get for the average is 1.53. I put this forumla in the StateServices Group =Sum(Fields!TotalTime.Value)/Count(Fields!Student_ID.Value)

  7. #7
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    nEVER MIND i got it wohooo finally

    =Sum(Fields!TotalTime.Value)/COUNTDISTINCT(Fields!Student_ID.Value)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •