Analytics Studio is an advanced reporting tool that gives you complete, granular control over your Mero data. For organizations that need to build highly specific charts and dashboards from scratch, Analytics Studio provides the ultimate flexibility.
Note: Analytics Studio is an optional add-on and must be enabled for your account. Please contact your Mero representative for more information.
Key Concepts
My Collection vs. Shared Collection
Analytics Studio allows you to organize your reports and dashboards into two distinct areas:
My Collection: This is your private workspace. Any questions, reports, or dashboards you save here are visible only to you. It's the perfect place to experiment with data and create personal reports.
Shared Collection: This is a collaborative space. Everything saved here is visible to and can be used by everyone in your organization. This is where you should save official reports and dashboards that the entire team needs to access.
Templates
To help you get started, Mero provides a number of pre-built templates for common questions and reports. These are a great starting point that you can use as-is or customize to fit your specific needs.
Understanding the New Reporting Data Tables
Three new data tables have been added to give you powerful new ways to analyze your data. You will see them when you create a new question.
Metric Daily Data: Use this table when you want to see trends on a day-to-day basis. It's perfect for reports that summarize activity for an entire day.
Use cases:
Tracking the total cleaning time per building each day.
Monitoring the total number of people (from traffic sensors) across a campus daily.
Creating weekly or monthly summaries of daily activity.
Metric Hour-Wise Data: Use this table when you need to analyze data for specific times of the day. It breaks down activity on an hourly basis (0 for midnight, 1 for 1 AM, 13 for 1 PM, etc.).
Use cases:
Identifying peak hours for restroom usage.
Analyzing cleaning activity during a specific shift (e.g., 9:00 AM to 3:00 PM).
Comparing morning consumable refill rates to afternoon rates.
Metric Tags: This is a crucial "connector" table. On its own, it doesn't contain metric values, but it holds the key to linking your data to locations, cleaners, buildings, and more.
IMPORTANT: To get meaningful reports, you must always join your
Metric Daily DataorMetric Hour-Wise Datawith theMetric Tagstable. This is the first and most important join you will make.
What Can You Measure? (The 'Key' Field)
Within the Metric Daily and Metric Hour-Wise tables, the key column tells you what is being measured. You can filter by these keys to create specific reports. The value column contains the corresponding number for that key.
Available keys include:
total_visit_time: The total time cleaners spent in a space.
total_people: The total traffic count from people counters.
number_of_cleaner_visits: The count of how many times a cleaner entered a space.
number_of_refills: The count of consumable refills.
median_refill_time: The median time it took to complete a refill.
total_refill_time: The cumulative time spent on all refills.
expected_time: The estimated time it should take to clean a space.
How to Build Reports in Analytics Studio
1. Creating a New Question (A Report/Chart)
A "Question" is the building block of any report. It's how you query your data to get an answer, which can be displayed as a table or a chart.
Step 1: Pick Your Starting Data
Click + New Question in the top-right corner.
Choose the base data table you want to work with. For most new reports, this will be
Metric Daily Data(for daily trends) orMetric Hour-Wise Data(for hourly trends).
Step 2: Join Your Data (The Most Important Step)
To connect your metric data to meaningful information like building names or cleaner names, you need to join tables.
After selecting your base data, click the Join data button.
First Join (Required): Select the
Metric Tagstable. Analytics Studio will automatically suggest joining on theMetric Tag IDcolumn. This links your raw numbers to an identity.Second Join (Optional but Recommended): Click the join button again. Now you can connect
Metric Tagsto other tables like:Locations: To see data for specific rooms or areas.Cleaners: To analyze data by individual cleaner.Buildings: To group data by building.Floors: To group data by floor.
Step 3: Filter Your Data
Narrow down your data to get the specific answer you need. Click the Filter button.
Filter by Key: This is very common. Click on the
Keycolumn and select the metric you care about (e.g.,total_visit_time).Filter by Date: Use a date column like
Campus Dateto select a time range (e.g., "Last 30 days").Filter by Location: If you joined the
Locationstable, you can filter byLocation Name.
Step 4: Summarize Your Data
Aggregate your data to calculate metrics. Click the Summarize button.
Metric to Calculate: First, choose the number you want to calculate. This will almost always be the
Sum of ValueorAverage of Value.Grouping: Next, choose how to group that calculation. This is where you define the report's structure. You can group by:
Start of WeekorStart of Monthto see weekly or monthly trends.Building NameorLocation Name(from your joined tables).Campus Hour(if using theHour-Wisetable) to see data by time of day.
Step 5: Visualize Your Results
Once you have your data, click the Visualize button at the bottom. Analytics Studio will often pick a smart default, but you can choose from many types: Table, Bar Chart, Line Chart, Pie Chart, or a single Number.
Step 6: Save Your Question
Click Save, give your question a descriptive name (e.g., "Weekly Cleaning Time by Building - Last Quarter"), and choose whether to save it to your personal collection or a shared one.
Example: Creating a "Weekly Cleaning Time per Building" Report
Start a New Question with
Metric Daily Data.Join with
Metric Tags.Join
Metric TagswithBuildings.Filter where
Keyistotal_visit_time.Filter the
Campus Dateto be "Previous 3 Months".Summarize by calculating the
Sum of Value.Group by
Buildings - NameandStart of Week.Visualize as a Bar chart. You now have a report showing the total cleaning minutes per building for each week of the last three months.
2. Creating a New Dashboard
A Dashboard is a collection of saved questions, allowing you to see multiple key metrics and charts on a single screen.
Click + New Dashboard in the top-right corner.
Give your new dashboard a name and description, and choose a collection to save it in.
Add questions to your dashboard: Click the plus (+) icon on the dashboard to see a list of all your saved questions. Select the ones you want to add.
Arrange and resize: Once added, your questions will appear as "cards" on the dashboard. You can click and drag them to rearrange the layout and drag the corners to resize them.
Add Text Cards: Click the text icon (Aa) to add text cards. These are useful for adding titles, descriptions, or explanations directly onto your dashboard.
Add Dashboard Filters: This is a powerful feature that lets you filter multiple cards at once.
Click the filter icon in the top right.
Choose the type of filter you want (e.g., a Time filter for dates or a Location filter for text).
Connect the filter to each relevant card on your dashboard, telling it which data field to apply the filter to. For example, you can make one date filter control 5 different charts.
Save your layout: Once you're happy with the arrangement, click the Save button. Now, anyone who views the dashboard can use the filters you created to dynamically explore the data.