I am new to Appsheet and trying to create a slice with the most recent 2 dates of a field called [date]
So the table is like this:
[ticker] [date] [value]
Ticker1 2021-01-02 10
Ticker 2 2021-01-02 11
Ticker1 2021-01-03 20
Ticker2 2021-01-03 15
Ticker1 2021-01-04 100
Ticker2 2021-01-04 120
The slice should return
Ticker1 2021-01-03 20
Ticker2 2021-01-03 15
Ticker1 2021-01-04 100
Ticker2 2021-01-04 120
It sounds very simple, but I canโt seem to find the right expression to make it work.
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |