Viewer Mode if using metric sheet as data source

I’m using a metrics sheet as the data source for a Chart Widget on a dashboard. The sheet is calculating values from a multiple-select dropdown, so I can't use a report as the source. I want users to see chart data that reflects the region they support, but "Viewer Mode" isn’t available for the Chart Widget—so I can’t display the chart from “their own perspective.” Is there a way to dynamically filter the chart based on the viewer’s region?

Answers