We have a number of devices that report to New Relic, and these devices each have a number of features that can be enabled or disabled at any time (per device). To track which features are enabled per-device, we have a ‘heartbeat’ setup which reports the status of each feature every 30 minutes. We are displaying these statuses with the following query:
SELECT latest(timestamp), latest(featureA), latest(featureB) FROM DeviceReportingEvent WHERE action='feature_status' FACET deviceId
featureA and featureB will either be true or false for enabled/disabled.
I would like to create a widget which counts how many devices have reported the latest status of
featureB as being enabled (true) to get a count of which devices have featureB enabled.
Is there any easy way to do this?