Splunk Search

How to get Daily average value of a field

jenkinsta
Path Finder

I have voltage data and want to get the average volts value per day for the last 7 days. 

This is where I left off from using bin to multiple timecharts and still nothing. 

source="/root/Scripts/VoltageLogger/Voltage.json" host="util" sourcetype="_json"
| timechart span=1d count by avg(voltage)

 

 

Labels (2)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

This should work - you are not counting, but calculating average, so use avg(voltage) like this

source="/root/Scripts/VoltageLogger/Voltage.json" host="util" sourcetype="_json"
| timechart span=1d avg(voltage) as avg_voltage

 

View solution in original post

0 Karma

bowesmana
SplunkTrust
SplunkTrust

This should work - you are not counting, but calculating average, so use avg(voltage) like this

source="/root/Scripts/VoltageLogger/Voltage.json" host="util" sourcetype="_json"
| timechart span=1d avg(voltage) as avg_voltage

 

0 Karma

jenkinsta
Path Finder

THanks, was close but long day and brain stopped working. 

0 Karma
Get Updates on the Splunk Community!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...