Forum Discussion
CalumS
Ambassador
AmbassadorKusto Query Language: Ep.9 – Parsing Complex Data Types.
Hi all, I am stuck on Question 6 as part of the KQL Parsing Complex Data Types. I have been doing adaptations of the following query to only get a blank AvgTime table each time. Event_CL | whe...
Hey, you're pretty close.
Try using `parse_xml` on the EventData, as it's in XML format and not JSON.
Then you can summarize the attribute directly like: `summarize avg(todatetime(EventData.DataItem["@time"]))`
Hey, you're pretty close.
Try using `parse_xml` on the EventData, as it's in XML format and not JSON.
Then you can summarize the attribute directly like: `summarize avg(todatetime(EventData.DataItem["@time"]))`
