• install influxdata
• insall nodejs
• run influxdb
• create bucket
• save the token to src/secrets.ts
• npm run start:dev

from(bucket: "scrap") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "ecoon.de") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")

from(bucket: "scrap") |> range(start: -24m, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "ecoon.de") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")

from(bucket: "scrap") |> range(start: -365d) |> filter(fn: (r) => r._measurement == "www.karton.eu") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group(columns: ["sku", "quantity"]) |> difference(columns: ["price"]) |> filter(fn: (r) => r.price > 0)