In this Tutorial we learn how to rank our records and find the highest or lowest of the rank using Rank node in Calculation view.
Let us consider a scenario where we need to find the highest mark of a students where each student has taken 3 Test each. Now we use Rank node to display the highest mark of the student
Below is the table which has the test details of the student.
Now creating a Calculation view with the table.
Drag the Rank node and place between Aggregation and Projection.
For our scenario I am going to select sort direction as descending (To pick the top mark) and “order by” should be your field which you wish to rank and get highest or lowest. In our case I am selecting Mark Field. We need mention student field as “Partition by” because it is going to be field which is going to be sort mark based on student.If we Enable Generate Rank column we will get another Rank field which will show the rank of the mark
Now it ll show the student’s mark which is highest of the three exam they have undergone. Below is the final result with Rank
