Store and display x:y data over time

Hello,

Daft question - Is it possible to capture and store an x:y array (IR spectrum) and overlay this as timeseries.

The FTIR equipment we’re using should output an IR spectrum every 10s seconds and will consist of about 1500 data points in an x:y array. Ideally, we would like to overlay this overtime for reaction monitoring purposes.

Can influxdb store and display this type of data?

Many thanks!

Hi @om327 -

To be clear your equipment outputs a Fourier transform with 1500 points (each being an x,y pair) across the spectral range every 10s, right? Ok, so as (or right after) Telegraf ingests the data, it can be transformed (i.e., re-formatted) into something more easily manipulated and/or processed downstream.

Since your problem statement is brief, I wouldn’t want to offer more specifics about how this might be accomplished.

1 Like

Hi Phil, Thanks for getting back to me! I have a python script dealing with the equipment interface and then have some options for passing the data out. I can potentially ingest this data as a single x:y array through MQTT, OPC UA or passing it using the Influx python API - which would you choose?

Is there a particular way we need to tell InfluxDB to expect an array rather than a single value in order to plot all the points but as a single timestamp?

Thanks again!

Are there any examples of spectra being ingested and stored by telgraf and influx? Would something like grafana be more suitable to display this type of visualisation or can native influx visualisations plot spectra?

Are you looking to plot 1500 points of amplitude and phase for every 10s sampling interval? Do you need all those points for analysis or is a visual graphic the final output?

As mentioned in your docker question, I’m about one week old with Telegraf/InFluxDB. But I’ve got a signals processing background. I now understand the collection side and knowing the desired end product(s) would help with recommendations about what goes in between.

1 Like

I have a similar application. Did you ever find a solution?
Cheers,
David

Sorry, not at the minute - there is probably a very simple way to do this but unfortunately, it’s not that obvious.