Grafana dashboard: Difference between revisions

From wikiluntti
VisualWikitext
(14 intermediate revisions by the same user not shown)
Line 7: Line 7:
Grafana_createDashboard.png|Creating a Dashboard is an easy task.
Grafana_createDashboard.png|Creating a Dashboard is an easy task.
Grafana_csv.png|Add the csv
Grafana_csv.png|Add the csv
Garafana localhost putty.png|Add the csv file from localhost using nginx.
Grafana_toTableFromwww.png|The Table works for the provided URL.
Grafana_toTableFromwww.png|The Table works for the provided URL.
Grafana organizeFields.png|You can rename the fields and choose the one to be displayed
Grafana convertFieldTypes.png|Convert field types to numeric. It likes to have them as strings.
Grafana divideTimeBy1000.png|Divide the time by 1000 to convert from ms to seconds.
Grafana xyplot.png|Finally the xy-plot works. Note the change of axis.
Grafana autoupdate refresh.png|Set autoupdate. Note that zooming is lost.
</gallery>
</gallery>


Line 44: Line 50:


=== GIS  ===
=== GIS  ===
Geomap
=== Window functions ===
https://community.grafana.com/t/grafana-v11-0-0-why-windows-function-mode-is-missing-in-data-transformation-menu/129571
=== Regression analysis ===


== Logs from Serial port ==
== Logs from Serial port ==


Use [[Arduino_radio_hc-12#Terminal_program|PuTTY]] and save (stream) logs to a file. Works like a charm. The notepad++ can be set to update automatically without asking (Ctrl-R reloads the file) by using <code>Settings -> Preferences -> MISC. -> Update silently</code>, but it still need Ctrl-R to reload the file.
Use [[Arduino_radio_hc-12#Terminal_program|PuTTY]] and save (stream) logs to a file. Works like a charm. The notepad++ can be set to update automatically without asking (Ctrl-R reloads the file) by using <code>Settings -> Preferences -> MISC. -> Update silently</code>, but it still need Ctrl-R to reload the file.
However, Grafana cannot update a local file. Instead use a web server (eg nginx) to serve the CSV files over http and then use http url (eg http://localhost/my-csv-app/my-csv-file.csv).
=== NGinx ===
See https://medium.com/@jasonrigden/how-to-host-a-static-website-with-nginx-8b2dd0c5b301
* Download, run
** <code>start nginx</code> and check with <code>tasklist.exe</code>. It should show two nginx instances. One of the processes is the master process and another is the worker process.
* Goto address http://localhost/ and the file location is at <code>nginx -> html</code>.
* Check config.
** <code>nginx.conf</code> is important. See <code>location</code> which states that root is html.

Revision as of 16:45, 3 April 2025

Introduction

  • From the left menu choose Data sources.

    From the left menu choose Data sources.

  • Finally the infinity after installing the plugin. Note the permissions of the folders.

    Finally the infinity after installing the plugin. Note the permissions of the folders.

  • Creating a Dashboard is an easy task.

    Creating a Dashboard is an easy task.

  • Add the csv

    Add the csv

  • Add the csv file from localhost using nginx.

    Add the csv file from localhost using nginx.

  • The Table works for the provided URL.

    The Table works for the provided URL.

  • You can rename the fields and choose the one to be displayed

    You can rename the fields and choose the one to be displayed

  • Convert field types to numeric. It likes to have them as strings.

    Convert field types to numeric. It likes to have them as strings.

  • Divide the time by 1000 to convert from ms to seconds.

    Divide the time by 1000 to convert from ms to seconds.

  • Finally the xy-plot works. Note the change of axis.

    Finally the xy-plot works. Note the change of axis.

  • Set autoupdate. Note that zooming is lost.

    Set autoupdate. Note that zooming is lost.

Grafana is a open source analytics application. It can produce charts, graphs, and alerts for the web when connected to supported data sources.

Running Grafana

  1. Start Grafana server (grafana-server.exe). My installation is at C:\Program Files\GrafanaLabs\grafana\bin
  2. Use web browser to go to http://localhost:3000/login
    • Default name and pwd is admin
  3. Create a data source. Connections -> Data sources. Enter Infinity
    • However, the plugin needs to be installed first: grafana-cli plugins install yesoreyeram-infinity-datasource. The permission of the folders have to be changed. Perhaps should allow all. Then restart grafana by:
      1. Open the Services app.
      2. Right-click on the Grafana service.
      3. In the context menu, click Restart.
  4. Create a dashboard
  5. Add visualization. Add the yesoreyeram-infinity-datasource data source
  6. Map is actually Geomap.

Examples

CSV Data

GIS

Geomap


Window functions

https://community.grafana.com/t/grafana-v11-0-0-why-windows-function-mode-is-missing-in-data-transformation-menu/129571

Regression analysis

Logs from Serial port

Use PuTTY and save (stream) logs to a file. Works like a charm. The notepad++ can be set to update automatically without asking (Ctrl-R reloads the file) by using Settings -> Preferences -> MISC. -> Update silently, but it still need Ctrl-R to reload the file.

However, Grafana cannot update a local file. Instead use a web server (eg nginx) to serve the CSV files over http and then use http url (eg http://localhost/my-csv-app/my-csv-file.csv).

NGinx

See https://medium.com/@jasonrigden/how-to-host-a-static-website-with-nginx-8b2dd0c5b301

  • Download, run
    • start nginx and check with tasklist.exe. It should show two nginx instances. One of the processes is the master process and another is the worker process.
  • Goto address http://localhost/ and the file location is at nginx -> html.
  • Check config.
    • nginx.conf is important. See location which states that root is html.
Retrieved from "https://wiki.luntti.net/index.php?title=Grafana_dashboard&oldid=13268"