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.
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).
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.
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 (
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).
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)
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.
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>
database– selecting a database, leave at
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
valuein 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 (
$__intervalis a variable which can be globally set up on the Options bar > Min. time interval)
valuein 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)
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.
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.
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.