Hi everyone,
I'm beginner on Splunk
I imported my data from a csv file, all the field is correct, I have 4 columns :
ID (String => 54BS26D)
Product Title (String => ABC PRODUCT)
Ordered Revenue (String => $20,530.42)
Ordered Units(Number => 256)
I had two issues :
1) I would like to do a sum of the revenue and i don't know how to do it because for Splunk the field "Revenue" is a string.
2) When i do the sum to find how many pieces i sold with [sourcetype="csv" | stats sum("Ordered Units")], i don't find the same result on excel, i don't know why.
Could you help please.
Thanks
... View more