Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I try to implement a Count of ID cummulated per year.
DATA:
ID | Timestamp |
1 | 14:00:00 01.01.2019 |
2 | 14:00:00 02.01.2019 |
3 | 14:00:00 01.01.2021 |
4 | 14:00:00 01.01.2022 |
Now I Like to display this Values based on year, so for 2019 the Count is 2 and so forth and so on.
Any help is highly appreciated.
With best regards
aggr(count(ID),year(Timestamp))
Do I have to insert it in the Expression tab of the Diagram? It does not show any Entries
I am using a Master Calendar by the wy, where I am setting up the Data via the TimeStamp Field.
Looks like the aggr() Function does not resolve the Result correct
Click on the component and his Expression will open. not on the Sheet.
add sum.
like this -
sum(aggr(count(ID),year(Timestamp)))