Skip to main content
Solved

Interface reporting that shows percentage of students who completed within a set day frame?

L
  • lydia
  • New Participant
  • 1 reply

Hello I am creating a time to value metric reporting system for our course.

Our goal is for our students to complete their first submission within our course in 14 days.  I have created a formula field that calculates the days from the student's enrollment date to the date they submit their first submission within our course. (see below).

So my question is; how should I create reporting in the base interface that reports the number/percentage of students who completed their submission within 14 days?

 

Best answer by JonathanB

You will need one field for the enrollment date, and another for the date of first submission.  Then use DATETIME_DIFF(... "days") to calculate the difference in days between these two dates.  Wrap this inside an IF() formula, so that you get an output of "Yes" if the difference is 14 days or less, and "No" if the difference is over 14 days (or there is no submission).  So this will be:

IF(DATETIME_DIFF({Submission date}, {Enrollment date})<=14), 'Yes', 'No')

Then just use the number box in your interface to count the number of records with 'Yes' in this field.

View original
    Did this topic help you find an answer to your question?

    3 replies

    J
    • JonathanB
    • Inspiring
    • 77 replies
    • Answer
    • January 6, 2023

    You will need one field for the enrollment date, and another for the date of first submission.  Then use DATETIME_DIFF(... "days") to calculate the difference in days between these two dates.  Wrap this inside an IF() formula, so that you get an output of "Yes" if the difference is 14 days or less, and "No" if the difference is over 14 days (or there is no submission).  So this will be:

    IF(DATETIME_DIFF({Submission date}, {Enrollment date})<=14), 'Yes', 'No')

    Then just use the number box in your interface to count the number of records with 'Yes' in this field.

    L
    1 person likes this
    • L
      lydia
    L
    • lydia
    • Author
    • New Participant
    • 1 reply
    • January 6, 2023
    JonathanB wrote:

    You will need one field for the enrollment date, and another for the date of first submission.  Then use DATETIME_DIFF(... "days") to calculate the difference in days between these two dates.  Wrap this inside an IF() formula, so that you get an output of "Yes" if the difference is 14 days or less, and "No" if the difference is over 14 days (or there is no submission).  So this will be:

    IF(DATETIME_DIFF({Submission date}, {Enrollment date})<=14), 'Yes', 'No')

    Then just use the number box in your interface to count the number of records with 'Yes' in this field.


    This worked easy peasy! Thank you so much! lol

    J
    • JonathanB
    • Inspiring
    • 77 replies
    • January 7, 2023
    lydia wrote:

    This worked easy peasy! Thank you so much! lol


    You're welcome 🙂

    Reply


    Most helpful members this week

    Terms & Conditions