## How does it work?

You can create a target value formula where the value increases every hour based on the relevant time of the day. Hourly targets can be a fun way to motivate your teams and give everyone a more immediate sense of achievement because they get to reach smaller milestones.

To create the hourly target formula, you need to use a basic IF statement. Since the Visual editor doesn't support IF statements yet, you will have to use the **Advanced formula editor**.

## Formula example

Say your team is keeping track of their daily performance, and the goal is to prepare 40 orders on a given day (or make 40 calls, or any other activity).

Everyone works for 8 hours a day. It means that on average, they should prepare 5 orders per hour. Once you know how much work everyone should do per hour, you have all the necessary information to build the formula.

Go to

**Formulas**>**+ New formula**.Click the

**Switch to advanced editor**button in the top-right corner.Copy and paste the formula from above.

Adjust the formula to match your own targets and working hours.

Keep the

**Decimal number**format.Click

**Save**in the bottom-right corner.

The formula expects an hourly target of **5**. The working hours are between 9 am and 5 pm (9-17), and the total workday amounts to 8 hours. With this formula, the target value of the first hour will be 5, the following hour it will be 10, then 15, and so on.

## How to use the formula

Once you save the formula, add it to a dashboard widget and set the time period to **Today**.

We would use the number box or speedometer because they can show two formulas at once (actual and target value).