Splunk Search

Need chart for two values

edrad80
New Member

Hi

I have a basic XML file returning, Date-time value and a value in seconds see example("GmtDateTime":"2013-08-14 01:15:26","TotalSeconds":15.593). There is one value every 30 minutes. I need to have a column chart showing x - date-time and Y - TotalSeconds.

I have tried a lot of different options today but can never get it showing correctly.
Just need a pointer in the correct direction

Tags (2)
0 Karma

edrad80
New Member

It almost works, the GmtDateTime is correct but it shows the average TotalSeconds for all instances instead of the correct total

0 Karma

linu1988
Champion

Provided you are having the fields correctly extracted, you can have |Timechart avg(TotalSeconds) OR Chart avg(TotalSeconds) by GmtDateTime.

Just a table GmtDateTime,TotalSeconds. where your primary axis should be GmtDateTime and TotalSeconds can be secondary axis in module for dashboard

|Timechart span=30m  avg(TotalSeconds)

I have updated the answer, hope it works.

0 Karma
Get Updates on the Splunk Community!

What’s New in Splunk Cloud Platform 9.1.2308?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2308! Analysts can ...

Index This | Why do they call it hyper text?

November 2023 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

State of Splunk Careers 2023: Career Resilience and the Continued Value of Splunk

For the past three years, Splunk has partnered with Enterprise Strategy Group to conduct a survey that gauges ...