I am trying to create a slice that contains the newest entry only. I see how to create a slice based on a date but not how to just make a slice of the newest entry and limit it to only that newest row.
If you have a โtimestampโ column, then:
[timestamp] = MAX(table[timestamp])
otherwise:
[_RowNumber] = MAX(table[_RowNumber])
Thanks, worked like a charm.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |