Entering Running Totals

By default, when creating a Number, you set a weekly target, and each week has the same target.

See also - how to set different targets for each week.

Workfacta calculates the total quarterly target for you by adding the weekly targets together: the quarterly-to-date target, or QTD Target. Similarly, Workfacta calculates the total updated results by adding them up, and it makes up the quarterly-to-date result or QTD Result.

Example: creating Numbers without ticking "Entering Running Totals"

Create a Number and select not entering Running Totals

By ticking "Entering Running Totals", you are setting the QTD Target. In this instance, you will be entering the QTD Result every time you update the Number. In other words, Workfacta will not sum the targets (results) up to calculate QTD Target (QTD Result).

This means that the users calculate the totals externally and enter the totals into Workfacta. The totals are not calculated by the Workfacta system.

Example: creating a Number tracking quarterly sales

Create a new number to track quarterly sales

In the example above, a user is creating a quarterly sales target "Quarterly golf balls ordered", and setting the target to 100. Instead of weekly new orders, the user wants to keep track of the total amount of golf balls ordered in this quarter. In this situation, the user ticks "Entering Running Totals" - meaning that each update is reporting the total amount of golf balls ordered in this quarter.

This way,

QTD Target is the exact same target the user sets - 100 golf balls ordered in this quarter;
QTD Result is the result that users update most recently - the total amount of golf balls ordered so far in this quarter.

In this following example of creating a Number to track the cost-per-click of a golf ball ad on Google, the user has set the target to be within the range of $1 - $2. By ticking "Entering Running Totals", the user is telling Workfacta that:

the QTD Target is that the cost-per-click is within the $1 - $2 range
the QTD Result is the cost-per-click that has been updated most recently

Example: creating a Number tracking cost-per-click

Use 'cost per click' as an example to create a Number and select entering running totals

Example: creating a Number tracking cost-per-click (cont.)

See the trend graph of the previous example of using 'cost per click' as an example to create a Number and entering running totals

Note: the "Entering Running Totals" option is hidden when you set the Number Type to be a percentage. Because Workfacta defaults that users are entering running totals if the Number is a percentage. See the example below.

Example: creating a Number tracking conversion rate in percentage

Create a new number with Number Type as Percentage

Entering Running Totals and Set For Each Week

You can set different targets for each week and tell Workfacta not to calculate QTD totals for you. To do this, tick both the "Set For Each Week" and "Entering Running Totals" options.

In the same example above, for the Number "Quarterly golf balls ordered", the user can set different targets for each week in order to achieve the total quarterly target of 100.

Example: creating a Number tracking quarterly sales with different weekly targets

Create a new Number to track quarterly sales and set different targets for each week

The different weekly targets will show in the trend graph as well.

Different weekly targets can be shown in the trend graph

To sum up, by ticking "Entering Running Totals", you are telling Workfacta not to calculate the total quarter-to-date target or quarter-to-date result for you. The system will see the target you set as the quarter-to-date target, and the result you update every time as the quarter-to-date result.

See also -

Customise your Numbers reporting - "Set For Each Week"