- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
![Splunk Employee Splunk Employee](/html/@F88B7774A2BF2E9108D79A067A92A581/rank_icons/employee-16.png)
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
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
![Splunk Employee Splunk Employee](/html/@F88B7774A2BF2E9108D79A067A92A581/rank_icons/employee-16.png)
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
![](/skins/images/396DDBEEAC295EB5FEC41FF128E8AC0A/responsive_peak/images/icon_anonymous_message.png)