How can I display a value cumulatively every hour?

[Alexander17]

How can I display a value cumulatively every hour?
For example 10:00 = 250 pieces, 11:00 = 200 pieces, 12:00 = 150 pieces.
The value should be displayed as follows

10:00 = 250 pieces
11:00 = 450 pieces
12:00 = 600 pieces

Which search command should I enter here?

Thanks in advance!

[scelikok · Accepted solution]

Hi @Alexander17,

I didn't notice "cumulative" 🙂

Please try below;

|timechart span=1h count as pieces | streamstats sum(pieces) as pieces

[Alexander17]

Perfect, it works!
Thank you very much and greetings from Germany!!!

[scelikok]

Hi @Alexander17,

You can use timechart command like below sample;

| timechart span=1h count as pieces 

[Alexander17]

Hello scelikok,

Dankr for the quick reply! Unfortunately it does not work. The values are displayed per hour so

10:00 = 250 pieces
11:00 = 200 pieces
12:00 = 150 pieces.

But this is how it should be

10:00 = 250 pieces
11:00 = 450 pieces
12:00 = 600 pieces