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
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