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.
try something like this
your search | chart sum(Amount) over Name by Month