I've got a search that ends with something like this:
| table category,available,total,percent
I've currently got the table color coded by percent, which is nice, but what I really want is to have a dashboard that has a single-value visualization per category that displays the available number, but is colored by the percent. Based on my reading of the Simple XML reference, I may be out of luck, since I can only color by the value or the trend. I'm also unsure how to generate a single-value per category in a dashboard.
In addition to ideas on how to do the above, I'd be delighted by other ideas for visualizing this data, too. I'm just looking for something with a bit more pop than the standard table.