Splunk Search

is it possible to have multiple levels at x-axis for chart

Punit
New Member

I am able to create a timechart graph successfully of what I need. The timechart displays the data for each day. Now there are events say A1, A2 .... such that , A1 occured from Mon to tuesday, then A2 occured from wednesday to friday and so on..and they do not overlap. Now imgaine the time chart is showing values for previous week. Now I wanna extract the values on x axis of timechart, search my database for the events which happened in that period. Then append it below x-axis, such that below the time in x axis on timechart it shows A1 from Mon to tuesday , A2 from wednesday to friday and so on, as the second level of x-axis.

Tags (2)
0 Karma

vasanthmss
Motivator

Hi Try this,

your search...| chart count over events by _time
V

somesoni2
Revered Legend

Not sure if that is possible, but you can try something like this (work-around)

Sample search (run anywhere): (selected timerange=2014/12/08 10:00 AM to 2014/12/08 10:15 AM)

index=_internal | eval Type=if(date_minute<11,"TypeA","TypeB") | timechart span=1m count first(Type) as Types | eval TypeA=if(Types="TypeA",-1000,null()) | eval TypeB=if(Types="TypeB",-1000,null())  | fields  - Types

In Panel->Format->chart overlay -> select column TypeA and TypeB as overlay columns.

Sample output:
http://i.imgur.com/sdWw06n.png

0 Karma

Punit
New Member

Thanks... but my column like the Type in yours, has more values than just two. Is there a method to dynamically achieve this creation of column TypeA, TypeB?

0 Karma

somesoni2
Revered Legend

Would you be able to put a quick image of mspaint or something on how it should look like. You can use http://imgur.com/ to upload image and provide link here.

0 Karma

Punit
New Member
0 Karma
Get Updates on the Splunk Community!

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...

[Live Demo] Watch SOC transformation in action with the reimagined Splunk Enterprise ...

Overwhelmed SOC? Splunk ES Has Your Back Tool sprawl, alert fatigue, and endless context switching are making ...

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us on ...