Hi,
I have problems to create the query for a Time series visualization. My InfluxDB data look like this. I have a Python script which is checking the prices for steam community items and writing it into the InfluxDB every 10 minutes.
Problem 1: The timestamp for all the inserts is over the range of round about 15 seconds.
This result comes from this query:
from(bucket: “STEAM”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == “csgo_case_prices”)
|> filter(fn: (r) => r._field == “total_value_eur”)
|> group(columns: [“case”], mode: “by”)
|> keep(columns: [“_time”, “_value”, “case”])
|> yield(name: “total_value_eur”)
Now I want a total value for the sum of all “case” entries for a timestamp +/- some seconds.
How can I do this?