- Relative Locating refers to locating to a position that is a certain number of cells/groups before or after the current records/groups. This kind of data computation is usually the typical SQL puzzles. However, esProc solves it easily.
- For example, to compute the month-on-month increase of sales volume of each month compared with that of previous month, you can simply use sales.(amount-amount[-1]) to represent it. Of which the relative number is represented as [n].
- Just another example, to find 3 months with the highest sales volume and their respective month-on-month increases.
- The Comparing with Last Period, Moving Average, and Add Up are the typical applications of relative locating. Please find the below example: