I kind of like what you have indicated here, but that is the maximum value, not the most recent. Thinking this through I might be better to do an average over the last 5 or 10 minutes to kind of indicate the server has been doing because instant may not be a clear picture.
I was starting to contemplate adding some views to the database and using Power BI instead directly against the DB.