Using Aggregated Calculations – Stratifyd

What are Aggregated Calculations?

Aggregated Calculations allow you to perform dynamic calculations on your data within table widget on a dashboard. This functionality addresses key calculation needs such as performing calculations on aggregated data, calculating averages of averages, addressing weighted scoring proportions, and creating ratios. Calculations of these types are often necessary for calculating and tracking KPIs.

Aggregated Calculations can currently be performed dynamically within the table widget. Within a widget, aggregations/calculations can be performed on original aggregations present in the table. Widgets that contain calculated aggregations react dynamically to dashboard filters like existing widgets today. Once you create and save an aggregated calculation, it will be saved and applied to your associated workspaces.

Who can use Aggregated Calculations?

This feature is available for all admin and power users.

When should I use Aggregated Calculations?

If you have more advanced analytic needs, for example performing averages of averages, weighted scoring proportions, ratios or other calculations, these dynamic calculated aggregations will help streamline the process by ensuring you can calculate these within the dashboard. Many clients have unique KPI or aggregation needs, such as:

Creating a weighted scoring proportion – ie. Weighting NPS based upon key segments such as loyalty/non-loyalty members, demographic criteria, etc.
Building ratios with the table

Building ratios – looking for period to period spikes in taxonomy categories to detect emerging categories.
Reporting a key metric as a percentage of total interactions, instead of raw number of interactions. This is helpful when fluctuations in volume are present.
- Support ticket total volume decreased significantly, but overall number of calls requiring an escalation increased slightly. This topic now represents a much greater percentage of overall calls than previous months. Track this percentage over time to better understand customer pain points.

How do I use Aggregated Calculations?

From your Stratifyd Workspace, click +Add Widget.
In the widget editor, add your fields and dimensions.
Apply the field filters as needed.
Edit custom values by clicking on the dropdown menu in the "custom" field.
In the modal that appears, enter the formula you would like Stratifyd to calculate and save it. We support addition, subtraction, multiplication, division, and remainder (modulo) calculations ( +, -, *, /, % ).
Name your calculation and hit Submit to save it. This widget will now be applied to all associated workspaces.