SQL window functions in Ruly allow you to perform advanced calculations across grouped data while keeping individual groups visible in your views.
You can use them to calculate averages, compare totals against overall averages, rank records, and determine percentages of a total.
By combining aggregate functions with window functions, you can gain deeper insights into your data, identify trends, and make meaningful comparisons without needing separate queries or additional views.
See how this is done by watching the short video clip below.
