Dashboards & Visualizations

How to add result of multiple searches to a single table

Aakanksha
Path Finder

for example suppose i have a search query which gives me results avg1 and name1,
and second search which gives a result avg2 and name2

now I want to create a table which contains these values of search1 & search2 as avgs and names

thanks..

[Edit]
Query1--
... eval add = x+y+z |eval name="xyz"|stats avg(add) as avg1

Query2--
... eval add=d+e+f | eval name="abc"|stats avg(add) as avg2

now-- result should be


name avg

-----------

xyz avg1

abc avg2

Tags (1)
0 Karma

rtadams89
Contributor

As previously mentioend you can use "append" or "appendcols", or you can use "join". If you use "join", you will need a common field to join on, but this can easily be accomplished by adding ... | eval joinOn="blahblahblah" to both searches, then use the new field "joinOn" (which has the same value in both searchs) as the field to join on.

I imagine you probably want to use append or appendcols though...

0 Karma

jonuwz
Influencer

Are they saved searches ?

MuS
Legend

Hi Aakanksha

you can do this by using join or with append and run two searches at once. The append command will not work on real-time searches.

example:

first | join [search second]

cheers,
MuS

MuS
Legend

yes, join works only on common fields in both searches

0 Karma

Aakanksha
Path Finder

i think join works on some common fields but i don't have any common field..plz correct me if i m wrong ..

0 Karma

lpolo
Motivator

You may use the search command appendcols.
More information:

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Appendcols

your_search_query_1|
appendcols [search your_search_query_2]|

Lp

Aakanksha
Path Finder

I have updated my question..and also i tried using appendcols but not sure whether i am using it correctly or not

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...