Discussions

Expand all | Collapse all

Average date of related records

  • 1.  Average date of related records

    Posted 06-29-2017 19:34
    I am trying to get the average date that students completed an assessment for each teacher. Is there a way to do this? If not, is there a way to just grab the date from ANY of the related students to populate the teacher table? Thanks in advance.


  • 2.  RE: Average date of related records

    Posted 06-29-2017 19:49
    If you have a relationship where 1 teacher has many assessments, you can edit that relationship to create a summary field of the maximum date of the assessments.


  • 3.  RE: Average date of related records

    Posted 06-29-2017 19:54
    Thank you so much!