In Data Explorer of IOT Central, the "Group by" does not contain the Telemetry fields

Question

Hello,

In Data Explorer of IOT Central, i dont see the Telemetry fields under "Group by".

i want to do Groupby on below Telemetry with groupby of press_count by button_name .

any idea?

thank you

Suheil

Telemetry name:SW0/SW1 button push event

{
    "button_event": {
        "button_name": "SW2",
        "press_count": 16
    },
    "_eventtype": "Telemetry",
    "_timestamp": "2023-11-25T03:45:23.315Z"
}

Answer 1

The Data Explorer in IoT Central only lets you use "Group By" on property fields, not telemetry. For more complex queries, you can use the Data Export feature in IoT Central - for example, you can export telemetry to Azure Data Explorer and build a query there, or use Power BI.