topic Re: How can I create a bar chart through 4 fields? in Splunk Search

How can I create a bar chart through 4 fields?

AtillaMaia — Tue, 16 Jun 2015 17:44:08 GMT

I'm using db Connect and I have this db input. So, I want a chart with 24 bars that represent range of hours. HourStart and HourEnd are that range and I get them in my query. For each interval (HourStart - HourEnd) I have Num which I also get it in my result. CurrentNum is used just for the current interval. For instance, now the current interval is 10AM - 11AM, so only for this interval CurrentNum will be used; the remains will be represented by 'Num' .

Re: How can I create a bar chart through 4 fields?

woodcock — Tue, 16 Jun 2015 18:52:40 GMT

Like this?

... | timechart first(HourStart) , first(HourEnd), first(Num), first(CurrentNum)

To make the visualization a bar chart, modify with the upper-left control and change it to "bar" or "column".

This is probably a poor guess at an answer but you have neither shown us your data, nor your search as it is so-far.

Re: How can I create a bar chart through 4 fields?

woodcock — Tue, 16 Jun 2015 19:48:10 GMT

OK, try this (HourEnd is implied by HourStart so it does not factor in):

... | chart avg(Num) AS Num avg(CurrentNum) AS CurrentNum over HourStart

Re: How can I create a bar chart through 4 fields?

AtillaMaia — Wed, 17 Jun 2015 15:14:22 GMT

For each, HourStart there is the specified value of Num

Re: How can I create a bar chart through 4 fields?

woodcock — Wed, 17 Jun 2015 15:25:43 GMT

Right; that's what is charted. If that is not what you desire, you need to restate your desire MUCH more clearly. I have been making educated guesses because you still have never been clear about what you are trying to do.

Re: How can I create a bar chart through 4 fields?

AtillaMaia — Wed, 17 Jun 2015 15:40:07 GMT

I really appreciate your suggestions! I'll try to explain again what I desire. Thanks