Dashboards & Visualizations

Combining multiple base searches into one dashboard chart

ChadW
Explorer

I have a dashboard with a couple of base datasources. Let's call them "base_search1" and "base_search2"

I have chained datasources which are used to output
base_search1 | stats avg(field) as a Radial
base_search1 | timechart span=1d avg(field) 

and the same thing for base_search2. This presents nicely as a radial and line chart for both base_search1 and base_search2.

Request: Now, I want to also display the radial and time chart for the combination of base_search1's results and base_search2's results. Assume both datasources both output the same field name that I want to average over. How do I do this? 

Will the solution change if I want to average over more than 2 datasources? Let's say I have 4 base searches on the dashboard.

If this was not on a dashboard, I would do something like base_search1 | append [base_search2] | timechart span=1d avg(field) but I don't know how that translates to working with datasources in dashboards. 

Labels (3)
Tags (2)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @ChadW,

it isn't possible to use more than one basesearch in a panel, you you should choose the most important of your searches and use it as base search, and then add the second search (not as basesearch) in the same panel's search.

Ciao.

Giuseppe

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...