Faux Dashboards

‘Dashboards’ are becoming a widely used buzzword in today’s work environment. I have found its much easier to present a report of one team’s needs than give them everything and have them fiddle with filters themselves

Take this roster for example:

I know that when this gets sent out, each district will break it out to their own team so why not do the heavily lifting for them.

Using the formula FILTER, and a dropdown, we can create a roster that only shows districts.

And then it frees up space for analysis.