Hello, in the ‘old graph’ mode it was possible to add time region at specific time
See blue lines in screenshot below
Is there a way to do the same thing in the new timeseries panel ?
Thanks
Hello, in the ‘old graph’ mode it was possible to add time region at specific time
See blue lines in screenshot below
Is there a way to do the same thing in the new timeseries panel ?
Thanks
What is your datasource
Hello,
The source is from InfluxDB2.0 via telegraf
from(bucket: "chaudiere")
|> range(start: 2022-05-14T05:25:00Z, stop: 2022-05-14T05:30:00Z)
|> filter(fn: (r) => r["_measurement"] == "chaudiereINFO_CHAUDIERE")
|> filter(fn: (r) => r["topic"] == "chaudiere_1/T.INTERNE/T.interne")
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> max()
With this i get the value for a specific date /time ( 05:25) and date !
I put it in annotation of the dashboard to get this :
:
What i would like is the same for every day at 05:25 …
i 'w working on something like this but from now it isn’t working:
import "date"
// jmoins1 = date.sub(d: 6h, from: 2022-09-16T12:00:00Z)
jmoins1 = date.sub (d: 24h, from: now())
annee = date.year(t: jmoins1)
mois = date.month(t: jmoins1)
jour = date.monthDay(t: jmoins1)
madatestart1 = annee + "-" + mois + "-" + jour + "T05:25:00Z"
madatestart = time(v: {madatestart})
madatestop1 = annee + "-" + mois + "-" + jour + "T05:30:00Z"
madatestop = time(v: {madatestop})
//strings.joinStr(arr:
//|> range(start: 2022-05-14T05:25:00Z, stop: 2022-05-14T05:30:00Z)
from(bucket: "chaudiere")
|> range(start: {madatestart}, stop: {madatestop})
// |> range(start: 2022-05-14T05:25:00Z, stop: 2022-05-14T05:30:00Z)
|> filter(fn: (r) => r["_measurement"] == "chaudiereINFO_CHAUDIERE")
|> filter(fn: (r) => r["topic"] == "chaudiere_1/T.INTERNE/T.interne")
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean")
As you see i’m a very poor programmer.
thanks
With foolowing code in annotation i get the vertical line for today
How can i do to reproduce this for 7 days ?
import "date"
import "strings"
import "dict"
//yesterday
// madatestart = date.truncate(t: -1d, unit: 1d)
// today
madatestart = today()
// found something like : 2022-05-13T00:00:00Z
// année du jour d avant
annee= int(v: date.year(t: madatestart))
// moi mois du jour d avant
moi = date.month(t: madatestart)
mois= [1: "01",2: "02",3: "03",4: "04",5: "05",6: "06",7: "07",8: "08",9: "09",10: "10",11: "11",12: "12"]
// changement en string + ajoute un zero pour les mois <10
newmois = dict.get(dict: mois, key: moi, default: "")
// jour d avant
jour = int(v: date.monthDay(t: madatestart))
tiret = ("-")
//heure = int(v: "T05:30:00Z")
madatestart1 = string(v: annee) + string(v: tiret)+ newmois + string(v: tiret)+ string(v: jour) + string(v: "T03:25:00Z")
// passage en mode time
madatestart2 = time(v: madatestart1)
// la meme chose pour le stop
madatestop1 = string(v: annee) + string(v: tiret)+ newmois + string(v: tiret)+ string(v: jour) + string(v: "T03:30:00Z")
madatestop2 = time(v: madatestop1)
from(bucket: "chaudiere")
//|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> range(start: madatestart2, stop: madatestop2)
//|> range(start: 2022-05-14T05:25:00Z, stop: 2022-05-14T05:30:00Z)
|> filter(fn: (r) => r["_measurement"] == "chaudiereINFO_CHAUDIERE")
|> filter(fn: (r) => r["topic"] == "chaudiere_1/T.INTERNE/T.interne")
|> filter(fn: (r) => r["_field"] == "value")
|> max()
Result :