By “search”, I think you meant query. I use only 1 query. In my example below (from Influx), you can see that there is only 1 query, and the “Calculation” function is “Last (not null)”. Have you tried playing around with all of Grafana’s settings to try to obtain what you are looking for? Often times that is the best way to learn any program.
Sorry for reopen this but the original question was if Gauge view can show sparklines or if Stat view in Grafana 8 can be turned into gauge view to have sparklines with gauge