We are getting an error Gauge Requires a Number because we are grouping by a text column for the gauge and gauge automatically grabs the first column. You also cant change the order of a group by and summarize columns.
We should be able to choose the column to display just like the number tile.
Same with Progress chart.