Dashboard metrics question: Mainly about filtering

fstdsg117

I have a master sheet which contains about 15 columns. The row entries are basically various issues that are distributed between 5 regional managers. I want to create an informational dashboard for the regional managers, such that they can view just the issues assigned to them. Additionally, I want only some specific columns to be visible, and not all 15, and also want to filter out some rows using certain criteria.

My initial idea was to do five different dashboards, but is there any way I could do all these in one dashboard. I must add, I have 4 other master sheets from which I will be creating 4 different metric widgets and placing them on one dashboard, in the four corners. Any advice on how to proceed would be helpful. Thanks!

@Paul Newcome Any ideas, please? Would really appreciate some help with this

fstdsg117

@Andrée Starå Any suggestions for this, please?

Paul Newcome

I would suggest a report. You can include/exclude certain columns, filter based on specific criteria, and filter on a contact column by "current user".