Splunk Search

how get combine result from two different search to a timechart

jackieh00
New Member

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?

0 Karma

pradeepkumarg
Influencer
(index=A "testx" ) OR (index=B "testx")| timechart count(user) AS total1 count(account) AS total2 | eval total=total1+total2
0 Karma

jackieh00
New Member

Thanks but I total still has total2 count, total1 number is 0.

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...