Any Tricks to Get a Metric Widget to Reference Report Data?

eahills

Hi,

I am looking to create 3 metric widgets in my dashboard that reference the cells highlighted in red from the report below...

It appears that I can only reference a sheet or sheet summary to create a widget. However, is there any work around to get this to work (i.e. build a sheet that references these cells, etc)?

Paul Newcome

You will need to either have formulas in a sheet that run the calculation or you would need to use a Report widget sized to only show those column headers and top row.