3 Create new metric
Carl Brochu редактировал(а) эту страницу 2019-05-09 14:56:38 -07:00

Metrics dashboard allows you to create your own metrics. This is useful when you want to debug or simply see the shape of data. In this tutorial you will learn how to create your own metric that will show up on the Metrics dashboard.

Steps to follow

  • Open or create a flow using first tutorial to create a pipeline in 5 minutes

  • Switch to the Query tab. Let's say we wanted to plot a chart for the count of devices sending data for house number 150. To do so, first, write a query to find the device count for house 150.

--DataXQuery--
T1 = Select COUNT(deviceDetails.deviceId) AS deviceCount
    FROM DataXProcessedInput
    WHERE deviceDetails.homeId=150;
  • Now use CreateMetric() API to create the metric. This API takes as input the table and column that has the information to plot on the Metrics dashboard. It returns a table which you want to output to the Metrics dashboard.
DeviceCount = CreateMetric(T1, deviceCount);

OUTPUT DeviceCount TO Metrics;
  • The full code for this, looks like below:
    New Metric

  • Click "Deploy" button. That's it! You have now created a chart called 'DeviceCount' that will show up on Metrics dashboard.
    Deploy

View Metrics

  • Switch to the Metrics tab and notice DeviceCount chart. New Metric

Note

  • You can also OUTPUT multiple Tables to Metrics as shown below (from the home automation sample). This will create a multi-line chart. Code snippet:
OUTPUT GarageDoorStatusOneForLocked, GarageDoorSlidingMinutesOpenedIn5minutes, GarageMinutesOpenedInAnHour TO Metrics;

New Metric

Links