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.
Hi Try this,
your search...| chart count over events by _time
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
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?
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.