Showing MIN and MAX per data series instead of entire result set?

I’m working with the table panel below that is visually formatted to display each data series/metric as an LCD Gauge.

My question is the following: how do I go about showing each data series (Metric A, B, C, D and E) using MIN and MAX values relative to the actual metric itself versus the entire data set from the query?

Anyone here that might know a solution to my problem?