Rank over partition

wiva posted Mar 18, 2023 at 10:00
Is it possible to add a rank over partition

I have a chronoforms 7 connectivity with on the first page a dynamic drop-down selection (to select a date from a read_data).

on the second action page a read data with a query field 'sum(totaal)' over the selection.
and a where condition "date" <= "selected date"
on the second view page a table list with two fields username and the result of the query field sum(totaal)
I want to add a field with the rank.

In a connection with 1 date the rank is perfect but i want also the possibility to select a range of dates, get the sum and rank by the result
You need to login to be able to post a reply. Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by