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!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...