Parameters

First, select and sync User Enrollments, Course Access and Course Access Log. Open Reports, select New report, then choose Start from a template and Class list course visits in the Query tab. Enter a Report name, select Run to check the results, then select Publish. Open your published report under Reports to try its inputs.

Its Inactive days input (inactive_days) defaults to 14. Set it to 7 for a weekly course or 2 for a daily course, then select Run. Compare the Inactive values with the default run: 1 means flagged, and the shorter threshold flags more people whose last course visit was earlier. This measures course visits, not grades or content completion. Select Reset to defaults, then Run to return to 14.

Add a parameter

In the builder’s Query tab, put a name between double braces in the query, such as {{inactive_days}}. Names start with a letter or underscore and use letters, numbers and underscores. Rowseta adds a card to Parameters. Set its Label, Type (Number or Text), and required Default. For numbers, set Min and Max when you need a range. Select Run to check the result, then Publish for a new report or Publish changes for a published report. When draft saving is available, edits autosave to your draft.

Change parameters when you run a report

On a report page, change a value above the results and select Run. Reset to defaults restores the saved defaults. If a value is invalid, the field shows its allowed range; enter a valid value and run again.

Next, run and export a report or edit its query.