How to display outstanding shipments in the dashboard?

Options

I've created separate shipping sheets for individual projects that detail if and when items have shipped.

In the separate shipping sheets, I have a symbols column titled "Item Shipped?" which offers a choice of "yes, hold, and no" which is signified with a tick, exclamation mark and a cross. I also have a date column titled "Shipment Date".

My goal is to create a dashboard that pulls data from each individual shipping sheet, based on "Item Shipped?" or "Shipment Date", and can let me know of any outstanding shipments company wide.

However, I'm struggling to create this mythical dashboard as the metric widget is displaying the data in a messy and unappealing fashion. Is it because "item shipped?" isn't a numerical value?

Any advice offered would be greatly appreciated.

Comments