3. Create Your KPIs

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

Last updated: July 1, 2022

How does it work?

To visualize your business performance on Plecto dashboards, you first need to build formulas based on the data in your data sources. To do that, you use a formula editor. It allows you to do different calculations, add filters and modifiers to pull specific data, preview the formula result, and more.

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.

KPIs - Two Widgets One Formula

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

Reusable formulas

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.

How to create a KPI

  1. Open your dashboard and click + Add widget in the top menu.
  2. Choose a widget and drag it onto the dashboard. Learn more about dashboard widgets.
  3. Click + Create formula (or the ➕ button on some widgets). The formula editor will open. Remember – a single formula can visualize multiple KPIs.
  4. Build a formula. Read our how-to guide or visit this page for inspiration.

Here are some KPI examples

Example #1 – Number of Deals (Current month)
  1. Add a widget to your dashboard and click + Create formula to open the formula editor.
    1. Give your formula a title (for example, Number of Deals).
    2. Add a new Data function component.
    3. Select Number of as the data function.
    4. 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.
    5. Click Save in the bottom-right corner.
  2. Set the time period to Current month and click Apply.
  3. Give your widget a title (for example, Number of Deals).
  4. Click Save.
Time period

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 #2 – Value of Won Deals (Current quarter)
  1. Add a widget to your dashboard and click + Create formula to open the formula editor.
    1. Give your formula a title (for example, Value of Won Deals).
    2. Add a new Data function component.
    3. Select Sum of as the data function.
    4. 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.
    5. Click Save in the bottom-right corner.
  2. (Optional )If you have a target formula, you can select it in the Target Value field.
  3. Set the time period to Current quarter and click Apply.
  4. Give your widget a title (for example, Won Deals).
  5. 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?