Dashboards & Visualizations

## Simple X over Y chart with any statistical functions

New Member

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

Tags (1)
1 Solution
Splunk Employee

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`

Splunk Employee

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`

Register for .conf21 Now! Go Vegas or Go Virtual!

### How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20. Learn More or Register Now >

Get Updates on the Splunk Community!