Thanks for your reply.
I'll try to explain a bit better below.
For example the table looks like:
timestamp | temperature | voltage | frequency | distance | ... 30 other colums
12:01:01 | 35.6 | 4.1 | 52.3 | 0.1254
12:01:01 | 35.4 | 4.09 | 51.8 | 0.1374
12:01:01 | 35.8 | 4.04 | 51.2 | 0.0637
We want to create a dashboard with a dropdown box with options: temperature, voltage, frequency, dinstance and the other 30 column names. So in the table are 35 types of measurements per unit of time (in our case per second)
When a column for example 'temperature' is selected, then all the questions below, lets say a graph with the values per minute for the last few hours. And a graph with all the mean values per hour the last day. A value stating the max value this day et cetera...
And when the user selects for example 'frequency' then all of the dashboard shows the insights for 'frequency' instead of 'temperature' that was selected before.