topic Re: How to make a bar graph with multiple bars for a category in Splunk Search

How to make a bar graph with multiple bars for a category

sakeebhossain — Mon, 24 Apr 2017 15:05:35 GMT

I have a .csv file that graphs the number of sales for three different businesses per month. has the columns, (Name, Month, Amount) with each row containing a business, a month, and how much they sold in that month. For example (Walmart, Jan, 210231024). I would like to make a bar graph which has each business on the X-axis and transaction amounts on the Y-axis. Then for each business on the X-axis, have a bar for each month. In my specific case, there are only 3 months to worry about (Jan, Feb, March). Can anyone help me make a query for this?

I'm new to Splunk and have to put together a demo quickly, so I'd appreciate the help.

Re: How to make a bar graph with multiple bars for a category

gcusello — Mon, 24 Apr 2017 15:21:24 GMT

Hi sakeebhossain,
try something like this

your search
| chart sum(Amount) over Name by Month

Bye.
Giuseppe

Re: How to make a bar graph with multiple bars for a category

sakeebhossain — Mon, 24 Apr 2017 15:24:40 GMT

Excellent, thank you!

Re: How to make a bar graph with multiple bars for a category

adonio — Mon, 24 Apr 2017 15:35:34 GMT

Hello there,
i created a small csv file and uploaded to splunk.
here are the results:

hope it helps

Re: How to make a bar graph with multiple bars for a category

LakshmiPrasanna — Thu, 19 Oct 2023 07:12:46 GMT

When one of the month data is not available in one of the name.. i am seeing empty space in between bars.. is there any way we can avoid that space