Skip to main content
Eptura Knowledge Center

Ratio Seating Problem Areas Dashboards

Purpose

Whether you follow traditional or agile seating, the Ratio Seating Problem Areas Dashboard identifies buildings and floors whose occupancy ratios fall farthest outside your prescribed target ratios and guides you toward actions to bring space use into conformity with your targets.

For example, you might set a +/- range of 0.1, indicating that any Assignment Ratio within 0.1 of the target is good to go. You can also override these targets, for example setting Override Target Ratio to 0.6 to ensure safe spacing, or, in a highly leveraged, agile workplace you might set your upper limit to 1.2.

In either case, this dashboard identifies outliers below and above these bounds, and lets you proceed to a detailed examination of a building’s stack by clicking on a building name.

When this dashboard is edited in the Insights Editors then you can enable cross-filtering, see Looker's documentation article called Cross-filtering Dashboards.

Special Data Elements

  • Target Ratio (Derived) - A weighted average of the Target Ratios within the Building/Floor.

  • Upper/Lower Bound - The bounds for determining outliers. Buildings & floors with an Assignment Ratio above the Upper Bound or below the Lower Bound will display in the Action Lists and Charts.

Special Filters

  • Override Target Ratio - When left blank, uses each building and floors Target Ratio (Derived). This may be different per building and floor. These values can be overwritten for this dashboard by entering an override, such as 1.2.

  • +/- Range - The range for determining outlying data. Increasing this value will increase the upper bound and lower the lower bound. Buildings and floors outside these bounds are highlighted across this dashboard

  • Click on a building name from the action list and see an option to link to see that building broken out in detail by floor in the Building Stack: Ratio Seating Performance Dashboard.

image2021-10-13_8-25-30.png