Splunk Search
Highlighted

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

Explorer

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.

0 Karma
Highlighted

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

Legend

Hi sakeebhossain,
try something like this

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

Bye.
Giuseppe

View solution in original post

Highlighted

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

Explorer

Excellent, thank you!

0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

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

hope it helps