Every One Model customer will have a unique set of metrics and dimensions built around their data sources and reporting requirements, but the side menu panel in Explore follows the same template for all users. Learn how to navigate the Metrics and Dimensions library.
When a user opens Explore, there are several 'action' buttons at the top, followed by four main headings: Time, Metrics, Dimensions, and Additional Columns.
Use the > to expand the left hand menu panel
Search function for the metric, dimension and column library
When building a query, click Run query to create the chart/table
When building a query, click Edit Options to manage visual options (e.g. legend)
When building a query, click Clear to clear all selections
Standard and customized time period dimensions can be found here. Click the name or icon to add the dimension to your query and then select the desired time period (e.g. last 12 months, today, or a specific day/month/quarter/year).
Metrics are quantitative measurements, e.g. number of hires, percentage of mature workers, termination rate of high performers. There is no limit to the number of metrics you can create in One Model, but typically, more data sources equals more metrics. We use recommended naming conventions, but customers have full control over naming and any changes are instant.
Your metrics are divided into Categories and Subcategories. In the highlighted example above, Headcount is the Category, Age is the Subcategory, and Age (Average) is the metric name. You can navigate to a metric by scrolling, or use the Search function.
At the top right of the Metrics section, permissioned users can click on Create/Edit to open the screen for editing Categories and Subcategories, creating a new metric, reviewing or editing an existing metric, or to delete a metric. You will find more information on Creating Metrics here
Dimensions are attributes of your data used for grouping and/or filtering metrics, e.g. Work Location, Employment Type, Diversity. Dimensions are created and edited by One Model to your specifications. Again, there is no limit to the number of dimensions, and they can be one level (e.g. Gender = Male, Female, Other at same level) or multiple level (e.g. Location = region > country > city across three levels, e.g. North America > Illinois > Chicago).
Dimensions are organized into Categories (e.g. Biographic) with the dimension name directly underneath (e.g. Age). You can navigate to a dimension by scrolling, or use the Search function.
The Additional Columns section in Explore enables users to select a column from the raw data tables to include in a List query. For example, if you are creating a simple list of current employees and their date of birth, you may select person_id, full_name and date_of_birth. These are raw columns direct from your data source that have not been converted into metrics, but are very useful in operational/list reporting. Tables may be cross-linked to enable more advanced reporting than your source system outside of One Model.
The menu consists of two types of columns:
Columns in data tables - the columns available to you are directly related to the data sources you are using in One Model but will typically include tables such as employee, employee event, application, requisition, performance. As shown in the screenshot above, the application table includes columns like application_id, latest_application_status and requisition_id
Columns in dimensions - as mentioned above, dimensions can be one level or multiple level depending on the reporting requirements. To distinguish dimensions from data tables, dimensions are labelled in the Additional Columns menu with "dim_" before the dimension name. E.g. "dim_engagement_score" is the Engagement Score dimension.
Unless the names have been changed via the administrative tool (Table & Column Label Editor), the columns will be labelled as "level1name", "level2name" etc.
Using the examples in the screenshots below, the Engagement Score dimension has one level, so you can select "level1name" as a column in your list report to return the data associated with Engagement Score, i.e. a value between 0.4 and 1. The Event Reason dimension has two levels, so you can select "level1name" and "level2name" as columns to appear side-by-side in your list report to return data such as Voluntary Termination, Redundancy.