View Calculations using Window Functions

Ruly makes it easy to add calculated fields directly to a View without creating additional fields in your database.

SQL Formula fields can handle simple calculations, such as calculating a claim total including tax, as well as more advanced calculations using SQL Window functions.

Use functions like `PARTITION BY` to calculate values across groups of records and `ORDER BY` to create cumulative running averages, giving you more flexibility when displaying calculated data directly within your Views.

See how this is done by watching the short video clip below.