Hi guys,
I am receiving some values in InfluxDB, however I want to plot them using Flux queries, but each time, multiply the value returned by the query by 60. For example, if the stored values are 1,2,3 I want the graph to show 60,120,180. My query is the following:
from(bucket: “***”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == “mqtt_consumer”)
|> filter(fn: (r) => r[“topic”] == “***”)
|> filter(fn: (r) => r["_field"] == “channels_0_value”)
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: “mean”)
Can you help me? Thanks!