Numeric Metric

Numeric Metric Settings

Display

Average	Returns the average aggregate value for the selected Number Field.   Configuration   Result
Count	Returns the number (count) of records for the selected App The Count option is the only Numeric Metric display option that returns the number of records. The Average, Maximum, Minimum and Sum aggregate options will only work on Number Fields.   Configuration   Result
Maximum	Returns the highest (maximum) value for the selected Number Field.   Configuration   Result
Minimum	Returns the total value for the selected Number Field.   Configuration   Result
Sum	Returns the average aggregate value for the selected Number Field.   Configuration   Result

Numeric Metric Formatting

Formatting lets you add additional styling options to the widget.

Prefix / Suffix	The prefix/suffix is used to give context to the Numeric Metric value.   Configuration   Result
Color Formatting	Color formatting is used to add color to Numeric Metric widget values when admin specified rules are met.   Configuration   Result   The rules are executed in order. If the Numeric Metric result satisfies more than one rule, the rule at the bottom will be applied.

Custom Formula

Custom Formulas allow you to gather better insights by dynamically manipulating Numeric Metric Widget results. Custom formulas can be added from the widget settings.

There are some predefined functions that can be used. You can access these functions by clicking on the fn icon.

These functions allow you to manipulate the rendered result; for example, showing percentages (%). Apart from these functions, you can use basic Math Operators (+, -, /, *) in the formula.

You can also use @ to reference other Numeric Widgets in the same Dashboard.

Some Examples:

Set the widget to display the SUM of used budget for this month. Create a formula to subtract the widget result from the Allocated budget.

Calculate the % of closed deals against the set target. Set the widget to display the COUNT of Deals and use a filter to only show deals closed in your preferred time interval.

Numeric Metric Filtering

You can apply two types of data filtering: widget filtering and saved views.

Widget filtering should be applied as a base filter.

For example, you might want a Numeric Metric widget to always display the Number (Count) of Projects assigned to the logged in user, as shown below:

Saved views can then be applied on the whole dashboard (unlike widget filters, that are applied per widget) and you can, for example, show only ongoing Projects, as shown below: