first of all, thanks for metabase, it is awesome!
Second, I set it up, everything is working fine and we created some dashboards.
With one dashboard I have some struggle, I’m shure I draw a mental blank so I hope, that someone can help me
We have a lot of testing probes (Water-level-mesurement of ground water). All Data is stored in one table of the database,
simplified: data_ID, DATE+TIME, waterheight, ID_of_sonde
example: 2456687;2020-09-15-09-45; 112.45; T231
There are several hundrets of sonde, each with its own ID_of_sonde. Every sonde has a lot of data, so a lot of rows in the table; also they measure at the same time - so at same timesteps, there are same DATE+TIME with different waterheights and different ID_of_sonde.
We need a dashboard, which shows the trend of one and more sonde in one diagram (one polyline for each sonde). X: time, Y: waterheight.
Metabase makes one large graph with an note (not-aggregated field DATE+TIME, because there are more values to the same time; that’s comprehensible, because there is no filter for a single sonde).
If I want to display the measurements in an way, that every sonde has it’s own graph, I need (in my way) for every sonde a single question. - And there lie my problem: I need to create hundrets of questions.
We have some other sonde (for rain), this are 10 and it’s okay. But for hundrets (and more are coming), this is a very time-intensive task.
Is there a chance to create different graphs for each ID_of_sonde of the single table automatically?
… like "filter for ID_of_sonde and draw for each ID_of_sonde a graph, additional show us the filter in the
dashboard (like the Field filter widget), that users can turn off graphs, which they don’t need.
Thanks for reading this wall of text, I hope I could express my problem (no native speaker).
I hope, there will be a possibility for this requirements.