We are using Azure TimeSeries Insights to store time series from various sensors from our devices. In order to faciliate querying of multiple related sensors at once i only use the deviceId (from IoT Hub) as a TimeSeries Id. This works for my backend queries and i can use the filter expression to filter by sensor id.
The only downside i discovered was that i am losing support for TSI Explorer because my value property in a time series contains values from multiple sensors. Display as a single graph makes no sense.
I thought maybe i can use the TSI Model to create fields which filter by sensor id so i get the same experience in TSI Explorer as if i would use a time series per device and sensor. But i didn't figure out how to do so.
So my questions are:
- Does the approach of merging multiple sensors of a device in a single time series have any downsides (besides the apparently lost TSI Explorer support) ?
- Is there a way to model the Time Series to get back TSI Explorer support back again?
@Markus, I am sure adding variable with a filter expression like "$event.sensorId.String = ''", will allow plotting time series on TSI explorer. However this would have a serious performance implications; especially when you have a large number of time series instances.
The most preferred method is to model each sensor (using composite TSID) as a time series and build hierarchy model to organize/contextualize data such that sensors are listed under a device as a parent in TSI explorer.
From TSI team, we would like to better understand your use case. If I may suggest something, please raise a support ticket in Azure portal with necessary contact details. we can get in touch to understand your use case here and better assist you in attaining your objective.