Numeric Metric

The Numeric Metric helps you visualize and keep track of key App metrics. The Numeric Metric can work with the following aggregate functions: Count, Sum, Average, Min and Max.

Numeric metric

Numeric Metric Settings

Note: The following examples use the Projects and Tasks Apps. See use case.




Returns the average aggregate value for the selected Number Field.



Numeric metric average config



Numeric metric average

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.



Numeric metric count config



Numeric metric count

Returns the highest (maximum) value for the selected Number Field.



Numeric metric maximum config



Numeric metric maximum

Returns the total value for the selected Number Field.



Numeric metric minimum config



Numeric metric minimum

Returns the average aggregate value for the selected Number Field.



Numeric metric sum config



Numeric metric sum

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.



Formatting Config



Numeric metric formatting
Color Formatting

Color formatting is used to add color to Numeric Metric widget values when admin specified rules are met.



Color Formatting Config



Numeric metric color formatting


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.

Custom Formula

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.

Reference Widgets

Note: When you reference the same widget you're currently writing the formula in, the raw result is used. However, if you reference another widget in the Dashboard, the custom formula result (if any) will be used. Widgets with custom formulas can't reference each other.


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.

Budget Config
Budget Result


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.

Budget Config
Budget Result


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:

Numeric filter

Note: Widget filtering will be applied to all users.

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:

Dashboard filtering

Note: Saved views are applied on top of widget filters. Unlike widget filtering, saved views are only applied to the user in context. You can share them with other team members.

What would you improve in this article?
Powered by:

Type above and the results will be displayed here.