Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I want to, "only sum the last value of each day-time data".
For example, if my data looks like below
I want to add the value of last date-time data(higlited the data what I want to add as bold style)
In this case so the Stock value will be (60+80+50), and Out will be(35+13+30)
And show the value in KPI in the sheet.
It would be greatful to know how to do this.
date/time | Stock | Out |
2022.03.12 08:00:00 | 30 | 20 |
2022.03.12 10:00:00 | 50 | 30 |
2022.03.12 15:00:00 | 60 | 35 |
2022.03.13 9:00:00 | 40 | 10 |
2022.03.13 12:00:00 | 80 | 13 |
2022.03.14 11:00:00 | 25 | 13 |
2022.03.14 18:00:00 | 50 |
30 |
Thanks in advance.
Why don't you try (for Stock): sum(if(aggr(nodistinct max(Time(date/time)),Date(date/time)) = Time(date/time),Stock))
Why don't you try (for Out): sum(if(aggr(nodistinct max(Time(date/time)),Date(date/time)) = Time(date/time),Out))
Hope this helps