3. Create Your KPIs

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.

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.

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.