Issues rendering kql query

pareshmotiwala — Thu, 16 May 2024 22:00:18 GMT

Hi folks

I am extremely new to KQL and fabric.

I am following https://learn.microsoft.com/en-us/fabric/real-time-analytics/kusto-query-set?tabs=kql-database

I ingested the Storms CSV into a new table as recommended by them.

I can see the data but when I run their query

NewTableDemo

|Summarize count() by bin(ingestion_time(), 2h) -- I tried 800 hours as well.

| render timechart --The time chart doesn't work as demonstrated in their page.

Can somebody help please?

Regards

Paresh

Re: Issues rendering kql query

Anonymous — Fri, 17 May 2024 02:11:26 GMT

Hi @pareshmotiwala ,

The x-axis field should be a datetime, Y-axis should be numeric values. Is ingestion_time() a datetime type column? You can refer the following codes to generate a time chart, please find the details in the following official documentation:

Time chart visualization - Azure Data Explorer & Real-Time Analytics | Microsoft Learn

StormEvents | where StartTime between (datetime(2007-01-01) .. datetime(2007-12-31)) and DamageCrops > 0 | summarize EventCount = count() by bin(StartTime, 2h) | render timechart with ( title="Crop damage over time", xtitle="Date", ytitle="Crop damage", legend=hidden )

Best Regards

topic Re: Issues rendering kql query in Developer

Issues rendering kql query

Re: Issues rendering kql query