Hi,
I am trying to make this graph they are temperatures the log is a CSV from a data logger.
Each entry has a unique time stamp.
I would like to make this graph be overtime without having to use a function like sum or avg. just a straight x over y graph excel style with all of the entries
source="C:\Users\gerard\Desktop\ilon.csv" | chart avg(Ambient_Air_Temperature) as "Ambient Air Temperature",
avg(Air_Supply_Temperature_Program_Pool) as "Air Supply Temperature Program Pool",
avg(Air_Supply_Temperature_Main_Pool) as "Air Supply Temperature Main Pool",
avg(Main_Pool_Temperature) as "Main Pool Temp",
avg(Program_Pool_Temperature) as "Program Pool Temp",
avg(Return_Air_Temperature) as "Return Air Temp",
avg(Solar_Panel_Temperature) as "Solar Panel Temp" by timestamp
I would also like a radial chart for each of these values to basicly display the temperature values in a gauge
any help would be great
cheers
Gerard
the classic way is
| chart avg(field) over x by y
if needed to regroup by numeric ranges, you can group using the bucket command
| bucket y span=10 | chart avg(field) over x by y
otherwise the basic timechart can be used is one of the variable is the _time
| timechart span=1h avg(field) by x
the classic way is
| chart avg(field) over x by y
if needed to regroup by numeric ranges, you can group using the bucket command
| bucket y span=10 | chart avg(field) over x by y
otherwise the basic timechart can be used is one of the variable is the _time
| timechart span=1h avg(field) by x