Page History

...

1. In the Repository, navigate to Public > Moodle/Totara > Ad Hoc Components > Views
2. Select the Course Completion Table View
3. In the Measures panel, hover over the Detail Selectoricon. The Details menu opens.
4. Select Create Calculated Measure. The New Calculated Measure window appears:
   
   Image Modified
5. From the Functions list, double-click Rank to enter it into the Formula box:
   Image Removed
   Image Added
6. In the Formula box, select the NumberFieldName so that it remains highlighted, as shown in the following image:
   Image Removed
   Image Added
7. From the Fields and Functions list, select the Course Completions ID. Double-click the Course Completions ID so that it replaces the selected text int he Formula box:
   
   
   Your formula (read as: Rank("Course Completion ID")) will create a calculated measure that assigns each Course Completion ID a ranking value.
8. Click the Validate button to ensure there are no errors in your formula.
9. In the Measure Name field, name your new measure "Row Number."
10. Click the Create Measure button. Your new Row Number measure will appear in the Measures Panel.

...