I have a CSV that has the setup as shown below.
Date |Score
1/1/2016 | 4.3
2/1/2016 | 5.7
I need to extract that date to be able to do trends on the scoring. I have no other way to ingest the CSV aside from just using an inputlookup.
Try this
| inputlookup csvfilename.csv | eval time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon | stats count by time
Try this
| inputlookup csvfilename.csv | eval time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon | stats count by time
bin command needed another argument with _time but that did work
| eval _time=strptime(Date, "%-m/%-d/%Y") | bin span=1mon _time |