Forum Discussion

pareshmotiwala's avatar
pareshmotiwala
New Member
2 years ago
Solved

Issues rendering kql query

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

Interesting Links
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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