How to plot over time the sum of iot values using last value rather than the cumulative sum

Elastic Stack Kibana
1

I have a simple CSV sample like that and i want to see the evolution of the sum, breaked down by de last value

date	evse	power
2024-02-12T10:00:00	evse_1	2
2024-02-12T11:00:00	evse_1	4
2024-02-12T12:00:00	evse_1	6
2024-02-12T13:00:00	evse_1	8
2024-02-12T14:00:00	evse_1	10
2024-02-12T15:00:00	evse_1	12
2024-02-12T10:00:00	evse_2	2
2024-02-12T11:00:00	evse_2	10
2024-02-12T15:00:00	evse_2	4
2024-02-12T10:00:00	evse_3	2
2024-02-12T13:00:00	evse_3	8
2024-02-12T15:00:00	evse_3	12
2024-02-12T10:00:00	evse_4	1
2024-02-12T11:00:00	evse_4	2
2024-02-12T12:00:00	evse_4	3
2024-02-12T13:00:00	evse_4	4
2024-02-12T14:00:00	evse_4	5
2024-02-12T15:00:00	evse_4	6
2024-02-12T10:00:00	evse_5	2
2024-02-12T11:00:00	evse_5	10

in this example i have 5 IOT elements that send power level at some time, i want to plot the sum of all the power over time using the last value received from the iot element as the value until a new one comes in

I don't understand how to do that with kibana

2

Hi @Julien_Revol. I think you might need to create a transform that writes the last value to a separate index. Then you could aggregate over the metrics using the new index.

Maybe similar to this example.