Is there a way to have the data within a Metric Widget to be sorted automatically in order?

edited 04/02/24 in Smartsheet Basics

I have data that is being ranked in order of how many errors occurring from most to least. I've organized these in the summary sheet of the reference sheet however currently I have to manually move the data by dragging them individually in the Metric Widget. Since my report could change based on the number of errors occurring, I was wondering if this can be automated within the Metric Widget?