Time-Range Specific Report-like Functionality on a Dashboard?
I've had a time trying to suss this out on my own, so I'm asking the community!
Is there a way to get the dynamic functionality of the Table widget on the Dashboards page to represent a _peak_ value over the time range specified by the user? Right now, the Table widget only reports the _current_ value for the dynamic list of resources that I've specified, and I'd love if I could have a datapoint represent that shows the 'peak' value over, say, the past 30 days. This is for capacity planning, and we're trying to get out of utilizing emailed reports for these where possible.
At present, I'm using the Graph Reports to trend this data, but in order to really _get at_ which device is driving what, users need to expand the graph, select 'data,' and then dump the resulting table to a CSV and do their own operations -- at which point, it's best just to use the report functionality ?
I would really love to use the Table Widget (or something else?) to list our 'dynamic resources' in order of 'peak value' over the dashboard's timeframe.
Is this possible, hack or otherwise?