ADVICE NEEDED - Data source selection and grafana capabilities

Hi everyone,

I am new to Grafana and would love to get some advice on whether below is possible to implement via Grafana+plugins and which data source would be most appropriate to set up for my project. Below are the visualizations, details of the data (type and per-second points to be received) and calculations done on “published” data.

After my initial research, using InfluxDB as data source seems appropriate but wanted to check in with the community to see if there was anything I missed.

Let me know if there is anything I can clarify further!

Visualizations

  • Tables

    • type 1: multiple columns, sorted by datetime. new data is appended (increasing row count)
      • would be 10 data points per sec max
    • type 2: multiple columns. new data updated values of cells in table
      • would be 10 data points per sec max
  • Plots

    • type 1: time series
      • would be 10 data points per sec max
    • type 2: time series resulting from calculation of another time series
      • calculated every hour

Notifications

  • Emails
    • Every X minute
    • Contains newly appended rows to Table type 1
    • Snapshot of table type 2
    • Snapshot of plots type 1 and 2

Any help is deeply appreciated!

useful resources:

@mattabrams thank you for your answer. These really helped on the alerting side but in terms of the calculations, is it possible to do complex calculations such as standard deviation on a rolling basis?

not sure but that’s a good question!