To drill down from a table , the table should have the field name to pass as the token.
From your original dashboard, i took host as drilldown token since host is part of result set
Dashboard 1
<dashboard>
<label>Source</label>
<row>
<panel>
<table>
<title></title>
<search>
<query>index=sc-perfmon (collection=cputime counter="% User Time") OR (collection=Memory counter="% Committed Bytes In Use") | stats sparkline(avg(Value)) as "Load trend", latest(_time) as latest_event, latest(eval(round(Value, 2))) as "Latest value" by host,collection |eval "Seconds since latest event"=floor((now() -latest_event)) | eval "Host metric"=case(collection == "CPUTime", "CPU time user %", collection == "Memory", "Memory in use %") | table host, "Host metric", "Latest value", "Load trend", "Seconds since latest event"</query>
<earliest>-7d@h</earliest>
<latest>now</latest>
</search>
<option name="wrap">undefined</option>
<option name="rowNumbers">undefined</option>
<option name="drilldown">row</option>
<drilldown>
<link>http://10.0.xx.xx:xx/en-US/app/sc_monitoring/per_host_kpis?form.host=$row.host$</link>
</drilldown>
</table>
</panel>
</row>
</dashboard>
Dashboard 2
I used the host which is passed from source to filter the result in search query
<dashboard>
<label>Target</label>
<row>
<panel>
<table>
<title></title>
<search>
<query>index=sc-perfmon collection=FreeDiskSpace counter="% Free Space" NOT(instance=_Total) host=$form.host$ |chart max(eval(ceiling(100-Value))) as disk_in_use over host by instance</query>
<earliest>-7d@h</earliest>
<latest>now</latest>
</search>
<option name="wrap">undefined</option>
<option name="rowNumbers">undefined</option>
<option name="drilldown">row</option>
</table>
</panel>
</row>
</dashboard>
You have to now look at your data and fine tune according to your requirement.
Hope this helps!
... View more