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

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

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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.