Hi @nathanluke86
Apologies for the delay in responding, I have been on holidays. Your query looks fine, and there is no problem with using tokens/dropdowns. The only thought I have is that the icons failing to load might happen becuase Splunk takes a bit of extra time to do the subsearch (the append). Lucky there may be a simple fix for this, try replacing teh last line with this instead:
|inputlookup append=t path.csv
so your whole query would look like this
index = iis dest_host=$dest$ src_host_name=$src$ status=*
| chart useother=false usenull=false count over src_host_name by status
| streamstats count as tmp
| untable tmp status count
| stats sum(eval(if(like(status,"2%"),count,0))) as good,
,sum(eval(if(like(status,"4%"),count,0))) as error, ,sum(eval(if(like(status,"3%"),count,0))) as warn
,values(eval(if(status=="src_host_name",count,NULL))) as src_host_name by tmp
| eval from=src_host_name , to="dest_host"
| fields from to error warn good
|inputlookup append=t path.csv
... View more