Info
Content

Dashboards

First Dashboard

You can create a new dashboard by clicking the PLUS icon > Dashboard on the Main Menu. You will see the option to add graphical components (Query, Visualization and Convert to Row - more description below). By clicking the Diskette icon next to the GEAR icon, you will save the dashboard.


Image: New Dashboard

Dahsboard Settings

After clicking the GEAR icon of the project above on the pane, you will get to the section of setting up the Dashboard. Here you can change the dashboard name, add a description etc. It is also possible to display the dashboard in the JSON format for the option to back it up (section View JSON).


Image: Dashboard Settings

Time scope of graphs can be changes in the upper right hand corner by clicking the CLOCK icon. By using the MAGNIFYING GLASS icon, you can zoom in the graphs. YOu can also refresh the graphs by clicking refresh or you can choose automatic refresh with a specific interval.


Image: Setting a Time Scope

New Component

You can add a new component to a new dashboard by clicking the Add Query button (recommended) or Choose Visualization. Additional components are added by clicking the Bar Chart+ icon on the upper pane.

Each component can be moved by dragging it by the upper pane with the name of the Query or you can change the size of the component by dragging its lower right hand corner. This behavior is almost identical with the one found in Windows OS.

If you would like to group components into a foldable section, add a new component and choose Convert to Row. All components below this line will be automatically added. The folding and unfolding can be done with the arrow on the given line (>, V).


Image: Preview of a Folded Row

Component Edits

You can edit a component by clicking its name in the header and selecting Edit. In the Component Menu, you can delete it (Remove), duplicate it (More > Duplicateú, or display a JSON configuration (More > JSON Panel).


Image: Editing a Component

Edits are divided into several sections

  • Queries - creating database quesries
  • Visualization - selection and setting up of graphical components (chart, alert, etc.)
  • General - general component settings (name, description, etc.)
  • Additional Settings - these settings are available only for some components (graph - Alert)
Queries

In this section you can select a database and put together a data query. The quesry can be put together through a click-tool with smart help. More queries can be done with the button Add Query; to display the resulting query, you can click the Query Inspector.

There is a global setting of the minimal interval at the and of all queries - $__interval parameter, then also time scope settings, and time shift.

Image: Database Queries

Basic Query Structure

FROM <database> <measurement(your-topics)> WHERE tag=value
SELECT field(<value(parsed-fields)>) <selectors(agregation-functions)>
GROUP BY time(<time-interval>) fill(<value>)
FORMAT AS Time series
ALIAS BY <your label>

Legend

  • database – selecting a database, leave at default
  • measurement – list of all measuring (topics) in the database
  • tag – other parameters of measuring (not required)
    • x-sender-id – user publishing the current message
    • x-source – channel used for sending the message
  • value in the item field – a list of found values found in the given measuring
  • selector – after setting up grouping (GROUP BY) the selector is used to receive aggregated values from a given interval
  • time-interval – grouping interval for data aggregation ($__interval is a variable which can be globally set up on the Options bar > Min. time interval)
  • value in the item fill – indicates how missing data will be interpreted
  • your label – own name of the measuring which must be present in case of using two Y axes (left and right)

Examples:
ZReceiving all data points of voltage from the topic example.1.voltage

FROM default example.1.voltage  WHERE +
SELECT field(voltage_Volt)
GROUP BY +
FORMAT AS Time series
ALIAS BY Raw Voltage

Receiving a mean value of pressure from 5-minute intervals from the topic example.2.pressure

FROM default example.2.pressure WHERE +
SELECT field(p_bar) mean()
GROUP BY time(5m) fill(null)
FORMAT AS Time series
ALIAS BY Pressure

Receiving a maximum temperature of the whole day from the topic example.3.temperature

FROM default example.3.temperature WHERE +
SELECT field(T_°C) max()
GROUP BY time(1d) fill(null)
FORMAT AS Time series
ALIAS BY Max temperature per day

Receiving temperature from the topic example.4.temperature and converting to Fahrenheit degrees

FROM default example.4.temperature WHERE +
SELECT field(T_°C) math(*1.8+32.0)
GROUP BY +
FORMAT AS Time series
ALIAS BY Temperature [°F]

Receiving a first derivative of vibrations from a second interval in the topic example.5.vibration

FROM default example.5.vibration WHERE +
SELECT field(vibration) mean() derivative(1s)
GROUP BY time(1s) fill(null)
FORMAT AS Time series
ALIAS BY dVibration / 1s dt

You can find out more about database queries in the official documentation for InfluxDB.

Visualization

After creating a query, it is possible to select a specific visual component. There is a wide array of charts, grahps, counters, text, and maps available.

Image: Selecting a Component

General

In the General section, you can change the name and description of the component. It is also possible to set up a pattern for repetition.

Image: General Settings

No Comments
Back to top