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 ta...
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

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