Yep my formatting was all messed up as you said. It was returning my sources separated by 'OR's instead of commas you need in a "IN list" statement. So to fix it I compiled a list of sources with stats and used 'format mvsep="," to separate the list values by comma instead of OR: sourcetype="text:jenkins"
| where source in [search index=jenkins_statistics event_tag="job_event" node="*" job_name="*" build_number="*" earliest=@d latest=now()
|dedup host build_url sortby -_time
| search (type="started" ) `utc_to_local_time(job_started_at)`
| convert timeformat="%Y-%m-%d %H:%M:%S" mktime(job_started_at) as epocTime
| eval job_duration = if(isnull(job_duration), now() - epocTime, job_duration)
| eval Duration = tostring(job_duration,"duration")
| eval job_result=if(type="started", "INPROGRESS", job_result)
| eval ExceededLimit = if(Duration > "01:00:00", "Limit Met", "Limit Not Met")
| eval source = if(ExceededLimit="Limit Met" AND job_result="INPROGRESS", build_url+"console",null())
| stats values(source) delim="," as search
| format mvsep="," "" "" "" "" "" ""]
| stats values(_raw) as Raw, values(search) by _time,source
|eval Stages = if(like(Raw, "[Pipeline] { (%)"),trim(substr(Raw,15),")"),null())
| sort - _time
| stats values(source) as Source, values(Stages) as Stages, values(Raw) as Raw, values(_time) as Time by source
| table source, Stages
... View more