Forum Discussion
SignIn Office Location
Hi, I am trying to develop a query which determines how many users sign in from each office around the country. For the location of each office, I have the latitude and longitude. The following wa...
let SignIn=
SigninLogs
| extend latitude_ = todouble(parse_json(tostring(LocationDetails.geoCoordinates)).latitude)
| extend longitude_ = todouble(parse_json(tostring(LocationDetails.geoCoordinates)).longitude)
| extend geohash = geo_point_to_geohash(latitude_, longitude_)
;
Thank you very much, Clive! I have no idea how I missed changing the "tostring" to "todouble". I guess one of those days....
- You also had a double underscore in this line, so you probably missed it because of that other error:
latitude_, longitude__)
Glad it worked!
