Speedometer

Use the speedometer to show the daily progress in reaching a target

Last updated: July 24, 2020

Scenario: This example shows that your team needs to reach a target value of $40,000 this month.
Having your monthly target shown in the start of the month may seem a little overwhelming and incomprehensible:

speedometer-2.png

But if the widget is used to show the daily progress instead of monthly, you will create a much better overview for your employees.

In the advanced formula editor, you can create the following formula to find the daily progress:

(
Sum(Target,Value)
*
(
NetworkDays(StartDate(),Today())
/
NetworkDays(StartDate(),EndDate())
)
)

Please remember to edit (Target, value), to reflect the name of your data source and field name.

Result

Your target will increase day by day. At the end of the month your target will reach 40,000. This gives you a much more comprehensible and manageable overview throughout the month.

The example below shows monthly Sales vs. Target the 27th of November:

speedometer-3.png

Daily progress - hour per hour:

Scenario:
Your company has a daily budget. Since the budget won't be reached until the late in the day, the speedometer will show red most of the day. Some people don't find it motivating to "be behind", so it can be a good idea to show it hour per hour.

In the advanced formula editor, you can write it like this:

speedometer-4.jpg

Explanation

5 is the number of sales you want to reach per hour.
8 and 17 in the If statement are the opening hours.

Tips & Tricks

Use conditional colors on the speedometer widget to see how far you are in reaching the goal.

Related articles:
Month To Date Index.
Month To Date Target.

Was this article helpful?