I'm starting to work on a small space payload that generate two sets of histograms (basically a radio wave signal), one with 512 bins and another one with 4096 bins. My plan is to use Grafana for data visualization, which would work perfect for my other metrics like temperature, status switches, etc.
I am starting to learn how to store data in InfluxDB to then use Grafana for visualization. But I'm curious on how would it be the best way to store the histogram data into InfluxDB. Is this something recommended for InfluxDB or should I have a combination of InfluxDB (for all the time series data) and a relational database like PostgreSQL (for the histogram data). I guess I could store the 512/4096 data as a HEX string in InfluxDB, but then I would have to figure out a way to translate it to use it in Grafana.
Do I store all 4096 data as fields? or separately with a tag with the bin number and a simple field for the bin data.
time | tags | fields
time histogram_type bin1 bin2 bin3 .. bin4096
or
time | tags | fields
time histogram_type, bin_number bin
I also know that InfluxDB has a function for a cumulative histogram, not sure if that is what I'm looking for. I just need to store the data and show it in Grafana.
Thanks for any help.