How do I create dashboards for each of my department heads to see the tasks of their team?

BriannaRocamora

I want to create 1 dashboard for each of my department heads to see all of their teams tasks across multiple sheets. (One for Finance, One for Implementation, One for Account management)

James Keuning

Create a report to rollup the different sheets into one report. Then create one version of that report for each of the dept heads (just add a filter). Then create one dashboard per head and park each report on the dashboard.

BriannaRocamora

Can I have a step by step for this

BriannaRocamora

When I add a filter to only show what their team is assigned to, it shows nothing

Genevieve P.

Hi @BriannaRocamora

Here's a free webinar that goes through building a Report with filters that may help: SmartStart: Reporting

BriannaRocamora

Is there a way to get an auto generated dashboard from a report?

BriannaRocamora

It keeps saying my data cannot be charted

Genevieve P.

Hi @BriannaRocamora

If you're looking to turn your information into a Chart Widget on a Dashboard, you'll need to use one level of Grouping and Summary in the Report. This is so that there are numbers to chart! 🙂

Here's a different webinar that may be more useful than the one above: Redesigned Reports with Grouping and Summary Functions

If you're still having trouble with this, it would be best if we could see screen captures of what you're seeing and what you want to do, but please block out sensitive data.

Cheers,

Genevieve