topic is it possible to have multiple levels at x-axis for chart in Splunk Search

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

Punit — Fri, 05 Dec 2014 20:55:37 GMT

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.

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

somesoni2 — Fri, 05 Dec 2014 22:57:05 GMT

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.

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

Punit — Mon, 08 Dec 2014 15:02:16 GMT

Link :http://i.imgur.com/tv9rzq8.png

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

somesoni2 — Mon, 08 Dec 2014 16:53:37 GMT

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

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

vasanthmss — Mon, 08 Dec 2014 16:55:38 GMT

Hi Try this,

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

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

Punit — Mon, 08 Dec 2014 22:06:31 GMT

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?