Multiple queries for single value panel?

Splunk Search

I have some

index=job_console source="*DEV2*"  "Finished:" | sort - _time
<_time value here> Result: 2018-10-16T12:43:04.100-0700  line:30  Finished: FAILURE

index=job_console source="*DEV2*"  "Finished: SUCCESS" | sort - _time
<_time value here> Result: 2018-10-16T12:15:14.888-0700  line:20  Finished: SUCCESS

index=jenkins_console source="*DEV2*"  "DATAFLOW " | sort - _time
<_time value here> 2018-10-16T12:43:03.125-0700  line:26  DATAFLOW FAIL: RFL_REPL

I want to display the last run status, which is "FAILURE" from the above first query, the last successful time time, which is from the second query, and the failure reason which is from the 3rd query in a single value panel, use the "title" fields.

Can I can do all three queries?

Thanks!

Get Updates on the Splunk Community!

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

If you stopped by the Builder Bar at .conf26, thank you! This year, we brought ...

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...