Im using the search below and basically want a chart showing last 12 dates going oldest to newest from left to right by date.
| inputlookup running_data.csv
| eval EP=strptime(Date, "%m/%d/%Y")
| eval Date=strftime(EP, "%m/%d/%Y")
| chart sum(sats) over team by Date useother=false limit=12
| fillnull value=0
The search was working fine up until January and year change, now the search only shows the last date in December and is missing the newest 01/02/2024 date. If I change the limit to be large enough to include all date entries in the csv file, I discovered the below:
Its putting the 01/02/2024 date before the oldest date in the csv, instead of putting that 01/02/2024 column after the 12/18/2023 date column. So its like its ignoring the year and going by month chronologically. Done quite a bit of searching on this to no avail, and seems like this should be an easy thing to do... Im not opposed to not using "chart" if someone has a better way. Ideally the search returns the last 12 dates from oldest to newest in the columns and then the team name and numbers sats on that date in the rows. Thansk for any suggestions!
... View more