The chat responses are generated using Generative AI technology for intuitive search and may not be entirely accurate. They are not intended as professional advice. For full details, including our use rights, privacy practices and potential export control restrictions, please refer to our Generative AI Service Terms of Use and Generative AI Service Privacy Information. As this is a test version, please let us know if something irritating comes up. Like you get recommended a chocolate fudge ice cream instead of an energy managing application. If that occurs, please use the feedback button in our contact form!
Skip to content
Insights Hub and Industrial IoT

Insights Hub drives smart manufacturing through the industrial Internet of Things. Gain actionable insights with asset and operational data and improve your processes.

IoT Time Series Aggregates Service – Selecting¶

Select Syntax¶

With the optional select parameter, it is possible to define which data to return. The value of the select parameter is a comma separated list of requested data. Each value in the list can either be a variable name or an aggregated field using a variableName.fieldName syntax. The field name can be one of the following:

  • countgood
  • countuncertain
  • countbad
  • sum
  • average
  • mintime
  • minvalue
  • maxtime
  • maxvalue
  • firsttime
  • firstvalue
  • lasttime
  • lastvalue
  • sd

If no select parameter is specified, all variables and fields are returned. If a variable is specified, but no field name, all the fields for that variable are returned. If a variable and field name are specified, only that field of the variable is returned. Variable names are case-insensitive.

Note

For charting, dashboarding customer should use select for critical fields to be plotted like average, minvalue, maxvalue. This will reduce read size drastically. It reduces read rate in tune of 50-70% basis on specific use case.