Dashboards & Visualizations

Simple X over Y chart with any statistical functions

gerardsimms
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)
0 Karma
1 Solution

yannK
Splunk Employee
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

View solution in original post

0 Karma

yannK
Splunk Employee
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

0 Karma
Get Updates on the Splunk Community!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...