How can i limk 2 reports into one within a single panel?

[ASISH_9]

I have two reports named positive and negetive variance in a single dashboard named time variance of a particular set of employees.How can i link these two report into one report named variance ?

[sundareshr]

Please provide more details... sample data, current queries, type of panel etc.

[chimell]

Hi ASISH_9
Use the search like this with appendcols command :

search 1 |appendcols [search 2]

example :

index=_internal |stats count by source |appendcols[index=_audit |stats count by sourcetype]