Metric Dashboard Widget - Create Values From Sheet



Currently I'm playing with building a dynamic dashboard for our customers. To do this I'm pulling data from our master sheet into a metrics sheet. From there, Im building reports using the current user filter and can add charts successfully. However, I cannot add a metric widget from the sheet.

I would like to add a metric displaying a count of hours spent for all items relating to a user and show the value in a dashboard.

I've looked into Sheet Summary and I can't see how this could work without creating a Sheet Summary for each customer and then dymanically add to the dashboard too.

Appreicate any help as always.

Many Thanks.