Issues rendering kql query

[pareshmotiwala]

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

[Anonymous · Accepted solution]

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