Search the Community
Showing results for tags 'count'.
We receive requests from customers every now and then asking whether we could display the number of devices/instances dynamically on a widget, either through a Big Number Widget or Custom Graph Widget. An ancestral practice involves creating a complex datapoint with a value of 1, and then aggregate the sum of this datapoint on the widget to retrieve the total number of devices/instances. This could be tedious as it involves changes made on the DataSource level. There’s good news, though - We have modernized and simplified this method after making a breakthrough on a recent ticket utilizing the following neat and simple method, and we’d like to share this idea with our users: On a high-level, the quintessence of this stratagem is as follows: 1) Identify a non-zero datapoint where you'd like to see it's devices/instance count 2) Configure an Aggregate SUM of this datapoint e.g. AggregateSUM 3) Configure an Aggregate AVERAGE of this datapoint e.g. AggregateAVG 4) Create a Virtual Datapoint with the following expression: AggregateSUM/AggregateAVG Note: Datapoint with NaN will not be counted as a device or instance in the process of aggregation. Example of device count configuration:- Example of instance count configuration:-