3. Create Your KPIs

Learn how to create custom KPIs to track your business performance in real time.

Last updated: Jan. 12, 2022

How does it work?

To visualize your business performance on Plecto dashboards, you first need to build some formulas based on the data in your data sources. A single formula allows you to extract multiple KPIs. You can build a formula to count the number of calls and use it to see the KPI for today, another KPI for the current month, a third one filtered by teams or employees, and so on.

All formulas are universal and reusable across all of our features. For example, you can use the same formula on your dashboard widgets, in reports, when setting up notifications or contests, and more.

example-widgets-same-kpi.png

An example of dashboard widgets using the same formula showing 2 different KPIs.

Note: A single formula allows you to visualize different KPIs thanks to the group by and other options available in the widget settings.

Formula editor

To build formulas in Plecto, you use what we call a formula editor. It allows you to do different calculations, add filters and modifiers to pull specific data, preview the formula result, and more.

You can open the formula editor under KPI management > Formulas > + New formula or access it directly from the widgets on your dashboard.

Create KPIs right on the dashboard

Add widgets and create your KPIs right on the dashboard:

  1. Click "+ Add widget" in the top menu and choose a widget. Learn more about dashboard widgets.
  2. Drag the widget onto the dashboard.
  3. Click "+ Create formula" (or the ➕ button on some widgets). The formula editor will open. Remember - a single formula can visualize multiple KPIs.
  4. You can now build your KPI.

KPI Examples

Here are two simple KPI examples to help you get started:

  • Number of sales deals for the current month,
  • Revenue for the current quarter.
Example KPI 1: Number of Deals
  1. Add a widget to your dashboard and open the formula editor.
  2. Give your formula a title (for example, Number of Deals).
  3. Add a new "Data function" component.
  4. Select "Number of" as the data function.
  5. Select the data source from where you want to calculate the result. You can further customize the formula by adding filters or modifiers. Learn more in How to Build a Formula.
  6. Click "Save" in the bottom-right corner.
  7. Set the time period to Current Month and click "Apply."
  8. Give your widget a title (for example, Number of Deals).
  9. Click "Save."

Be aware: You must select the time period on the dashboard widget. The formula editor only gives a preview of your metrics and the time period.

Example KPI 2: Revenue
  1. Add a widget to your dashboard and open the formula editor.
  2. Give your formula a title (for example, Revenue).
  3. Add a new "Data function" component.
  4. Select "Sum of" as the data function.
  5. Select the data source from where you want to calculate the result. You can further customize the formula by adding filters or modifiers. Learn more in How to Build a Formula.
  6. Click "Save" in the bottom-right corner.
  7. Set the time period to Current Quarter and click "Apply."
  8. Give your widget a title (for example, Revenue).
  9. Click "Save."

Fill out your dashboard with more widgets and KPIs that match your business needs! 🚀 You can further customize your KPIs by adding different filters and modifiers, targets, and conditional colors. Learn about the formula editor and find more formula examples in How to Build a Formula.

Step 4: Set up your TVs and mobile devices! 📱

Was this article helpful?