Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 05, 2023 01:39 PM
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?
Solved! Go to Solution.
Jan 06, 2023 12:59 AM
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.
Jan 06, 2023 12:59 AM
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.
Jan 06, 2023 11:06 AM
This worked easy peasy! Thank you so much! lol
Jan 07, 2023 10:36 AM
You're welcome 🙂