I have a search from an input looup and i have appended search results from an index so i can overlay some results but the dates are not matching up.
| inputlookup user | where stat1=1 OR stat2=1 AND tonumber(strftime(_time,"%Y")) > 2019
| eval Date = strftime(_time,"%d")
| timechart span=1d max(Date) as days, count as Registrations
| eval DayRate = round(Registrations /days, 1)
| fields - days
| appendcols [search index="index1" | stats values(Confirmed) by Date]
This shows me results as per the below where the overlay red line should match the dates of the rest of the graph
As you can see the dates are not aligning as per the below
if you can advise on how i can correlate the dates to the same row.
I tried append and join with no luck
| appendcols [search index="index1" | stats values(Confirmed) by Date]
→
| append [search index="index1" | stats values(Confirmed) as Confirmed by Date | eval _time= strptime(Date."+0000", "%FT%TZ%z") | fields - Date]
| stats values(*) as * by _time
| appendcols [search index="index1" | stats values(Confirmed) by Date]
→
| append [search index="index1" | stats values(Confirmed) as Confirmed by Date | eval _time= strptime(Date."+0000", "%FT%TZ%z") | fields - Date]
| stats values(*) as * by _time
@to4kawa
I cant seem to convert your comment to an answer. Can you post as an answer again and ill accept
I see,
It was nice to run.
Sorry, my mistake as i still had appendcols, your answer is correct and will convert
Thanks but this still hasnt worked and date still stops at 12th april.
With my _time field in index=index1 this is data imported via HEC so each field has the same _time and i can only go by the Date field