I have 2 search
search 1
index=A "testx" | stats count(user) AS total1 by _time
search 2
index=B "testx" | stats count(account) AS total2 by _time
I want a timechart span=1d with count total1, total2, and total1+total2.
I've tried this,
index=A "testx" | stats count(user) AS total1 by _time| appendcols [search index=B "testx" | stats count(account) AS total2 by _time] | eval total = total1 + total2| timechart span=1d count(total1), count(total2), count(total)
but the total only has total2 count. How can I fix this?
... View more