# How do I create Formulas in Plecto?



##### Post Metadata
- Posted at: over 6 years ago
- Net upvotes: 1


## Comments
### Comment 1

This tutorial will show you how to create formulas and visualize your KPIs on your dashboard.

Formulas are at the core of Plecto. Every number that is displayed on a dashboard comes from a formula. With them, you can express a wide range of calculations that should be made on your data.

Formulas are saved as plain text, however, for it to work correctly it must follow a very specific syntax. You can think of it as a programming language. The language is similar to that of Excel or other spreadsheet software.

Your data in Excel are rows in a spreadsheet and you can filter and manipulate this data based on it's columns. Similarly, in Plecto, registrations are the rows and fields are the columns.

How to create a formula directly from the dashboard:

- Go to your dashboard and click 'Edit' in the upper right.
- Choose a widget (I have chosen a number box).
- If you have not yet created a formula, you can do it directly from the dashboard by 
   clicking 'Add new formula'.
- Select 'Quantity' (as I would like to count all sales made), and choose your data 
   source.
- Save it. 
- Choose your time periode; day, week, month, year or custom. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Marketing Automation Manager hos Plecto




## Related Product
[Plecto](https://www.g2.com/products/plecto/reviews)

## Related Category
[Sales Performance Management](https://www.g2.com/categories/sales-performance-management)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4