I got a project where I have a csv file with one particular field. Each bar ranges from 200-700 in value. I need to be able to multiply the values in the x-axis by the numbers on the y-axis and put the resultant number on the y-axis.
Based on your description, this should work, although you still didn't give any field names or show your search. For my example, I will assume that the field name in the csv file is "Number." You will have to fill in the search, it is probably something like "source=myfile.csv"
yoursearchhere
| chart count by Number
| eval count=count*Number
Pick the visualization that you like to show the results: bar chart or column chart will probably work well.
As others have said, we need more information. Clearly the list of sample data didn't help us to help you.
You talk about the X-axis and Y-axis - what do you mean by that?
If you could simply show the Splunk commands that you are using, and possibly a few lines from the Statistics tab (if you have any results to show), I am sure the community could help quickly and easily.
If you don't have anything else, at least run a search and use the | table
command to list the fields of interest.
It's really difficult to provide any suggestion without proper sample data. Also, is the data indexed in Splunk OR added as lookup table files (since this is CSV)?
Generally, If you've a search generating two columns X and Y, and if you want to calculate another Value as X*Y
to be plotted in y-axis, then we do like this
your current search giving field X and Y | eval Z=X*Y | table X Y Z
Use chart visualizations like line/column/bar/area chart.
Based on your new comment , try this
Your current search giving data with field X | stats count by X | eval Y=count*X
Please share some sample data
3
10
20
3
20
20
20
3
20
2
10
5
20
5
1
1
20
3
2
1
3
2
2
5
3
20
5
20
3
5
20
1
3
here is the data. i need to chart out the numbers on the x axis and the number of times each value occurs times the value itself. example 20 occurs 10 times y axis will be 20*10
Hi @nitro345
If you're sharing sample data, please be sure to highlight all of it and click the "Code Sample" button in the text editing tools to make sure special characters render properly.
The format doesn't seem right. This appears to be all in one column. Please post it as an image