Skip to main content

Individual Employee Targets

Plecto DocsFeaturesFormulasInspiration

Step 1: Create a manual data source

Creating employee targets in Plecto is easy. All you need is to create a manual data source and enter the target values.

  1. Go to Data management > Data sources > + New data source.

  2. Scroll to the bottom of the page and choose Sales target under Manual data entry. You can always rename the data source later.

  3. Click Confirm to finish and create the data source.

  4. Move on to Step 2.

Step 2: Add targets

To create targets, you need to add new registrations for each employee in your data source.

  1. To add a registration, click + New in the top-right corner.

  2. Select an employee and enter their target in the field Amount.

  3. Click Save. Repeat these steps to create targets for all the relevant employees.

  4. Once you're done, move to the next step.

Step 3: Create a formula

Now you can create a formula that calculates the sum of the target values.

  1. Go to Formulas > + New formula.

  2. Add a Data function component.

    1. Lookup function – Sum of

    2. Data source – Select the data source you created in Step 1

    3. Field – Amount

  3. (Optional) Add prefix or suffix in the bottom-left if you want to show the currency next to the target value. For example, EUR 20 000.

  4. Click Save in the bottom-right corner.

  5. Move to Step 4.

Step 4: Add employee targets on dashboards

You can now add your KPIs to dashboards. The best way to get an overview and compare the actual values with employee targets is by adding a table widget to the dashboard.