Hallo everybody!
If got a column "Name" an a column "DateTraining"
Name1 | 01.01.2022 |
Name2 | 02.02.2022. |
Name1 | 03.03.2022 |
Name2 | 04.04.2022 |
Name3 | 10.10.2021 |
The Return has to look like this: (show the LatestDate of DateTraining)
Name1 | 03.03.2022 |
Name2 | 04.04.2022 |
Name3 | 10.10.2022 |
How can i do this?
Check out this video.
Thanks for the very good Video, but
index(
orderby(
[Name],
[DateTraining], true
),
1
)
return a Error "ORDERBY has invalid inputs"
I have now found the reason for the error.
orderby expects a KeyValue as the first argument.
But I can't set "Name" as a KeyValue. For me, this is the "Timestamp" column.
Any idea how I can solve this?
And wrap it in Unique. Unique(Sort())
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |