Using Grafana for UltraTimeSeries dashboards

Connection from UltraTimeSeries to Grafana

The connection from Grafana to UltraTimeSeries is made through requests to our API. For that, it is necessary to install the JSON API for Grafana plugin to handle API requests.

To install the plugin, go to the settings page and then the plugins tab. Search for JSON API, and click install.

After that, it is necessary to create the data source using the JSON API plugin. To do this, go to the settings page, then the data sources tab. Click on "New Datasource" and choose the plugin you installed earlier.

Data search in the API

In each panel’s edit, we will select the configured JSON API plugin as data source. Then the following tabs will appear: Grafana tabs

Starting with the Path tab, we need to indicate in which path of our API we want to get the data, for example:

Grafana path

If the API request requires sending parameters, these will have to be indicated on the Params tab, for example:

Grafana params

Finally, the Fields tab: this is where we select the data we want to get from the API's response. Like this:

Grafana fields

Graphics Construction

To build a chart, you need to create a dashboard, as shown in the image below.

Grafana dashboard

Then the chart type can be chosen in the upper right corner and below are presented some types of graphs that can be built.

Time Series Graphs

Data Format: pair of {date, value}

In this type of chart, we are able to produce these different results:

In this first example, we can see a simple chart of time series visualization:

Grafana chart1

Another example is to join different temporal data on the same graph, like this:

Grafana chart2

This last chart can be configured as two requests (or more) to the API for the same chart, like this:

Grafana chart3

In this type of chart, we have many options, and the most relevant are:

Set thresholds

  • They can be found, in the tab on the right, in the tab thresholds section

Grafana chart4

Interactively select time periods

Manually set min and max

  • For example, [2660, 2700] Grafana chart5

Multiple Y-Axis

Grafana chart6

Grafana chart7

Mix chart styles

Grafana chart8

Bar Chart

Data format: {key, value} Grafana chart9

Grafana chart10

Pie and Donut Charts

Grafana chart11

Grafana chart12

State Timeline

  • With the time series data, we can build this graph, where we can map the values to a string and a color. With this graph, we can see at what point in a day (for example) the data of a sensor was above or below certain limits.

Grafana chart13

Grafana chart14

  • This value mapping can be found on the right side tab in the panel edit.