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

[sakeebhossain]

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.

[adonio]

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

hope it helps

[LakshmiPrasanna]

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

[gcusello · Accepted solution]

Hi sakeebhossain,
try something like this

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

Bye.
Giuseppe

[sakeebhossain]

Excellent, thank you!