Splunk Search

Timechart how to keep latest value

New Member

I'm getting in my splunk database a set of data coming from 8 sensors
Those 8 sensor work in a consecutive sequence
That means that when I get the info only 1 of the 8 set of data is updated

Currently my timechart shows only the last set of data all the others are 0 (zero)

index="morfi" | timechart bins=100 cont=false last(S3_F_Lp)

In the bellow image each column represent one sensor set of data

Thanks for your help



Labels (1)
Tags (1)
0 Karma

New Member

Thnks for coming back to me.

No in fact we want to have each column showing one sensor, what we already have.

what we don't have and would like to have is to see the latest result (<> 0) of each sensor and not only the one of the last sensor that has sent data.

What is happening currently is that the value of sensor S(i)  value drop to zero as soon as the data S(i+1)  is loaded.
We would like to keep the last value of each sensor.

index="morfi" | timechart bins=100 cont=false last(S1_F_Lp)

On an other dashboards we are getting this OK with a different display type
| stats latest(S1_F_Lp) as " S1_F_Lpmm", latest(S2_F_Lp) as "S2_F_Lpmm", latest(S3_F_Lp) as "S3_F_Lpmm", latest(S4_F_Lp) as "S4_F_Lpmm", latest(S5_F_Lp) as "S5_F_Lpmm", latest(S6_F_Lp) as "S6_F_Lpmm", latest(S7_F_Lp) as "S7_F_Lpmm", latest(S8_F_Lp) as "S8_F_Lpmm"


0 Karma

Splunk Employee
Splunk Employee

Could you send a sample of your data to understand your question better? And what are you looking to show - average across the 8 sensors or?

0 Karma
Get Updates on the Splunk Community!

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...

DevSecOps: Why You Should Care and How To Get Started

 WATCH NOW In this Tech Talk we will talk about what people mean by DevSecOps and deep dive into the different ...