Existing Active Enrollments measure in BI Publisher using a particular time period
Summary:
I need to build Existing Active Enrollments measure in BI Publisher for Learning Module using p_start_date and p_end_date
Content (please ensure you mask any confidential information):
I started from the following definition:
Number of Existing Active Enrollments=Enrollment Date before start of time period and completion date greater than or equal to time period start
The metrics which say "Existing" are meant to show how many cases there were at the start of the period.
Version (include the version you are using, if applicable):
The parameters were set like that:
The point is that i received the name of the course/person number but the measures give me 0 result for each course: