Forum Discussion
rangari
Feb 05, 2020Copper Contributor
Ability to see customDimensions in Azure logs under ItemType Drop Down
Hi, I am using Custom Events to track some user activity. For Example- In our Application every user can set a preference to have certain number of Search results per page. Options being (25,50...
CliveWatson
Feb 06, 2020Former Employee
You probably need to get that column as an integer, very rough example (using a datatable as a fake input):
datatable (TimeGenerated:datetime, ItemType:string, customDimensions:string)
[datetime(1910-06-11), "customEvent", '{"resultsPerPage":"25"}']
| project TimeGenerated, ItemType, customDimensions
| extend rsltsValue =split(customDimensions,":").[1]
| project TimeGenerated , ItemType , val = toint(trim(@"[^\w]+",tostring(rsltsValue)))
Go to Log Analytics and run query