Oct 30 2019
- last edited on
Apr 08 2022
When I pin a query to a Dashboard, such as a graph, I find that the X axis of the graph does not display correctly. It shrinks the view of the labels on the X axis , even if you make it as big as possible.
For example, I have a query for activity per user over a period of time. It lists the 'Caller' email@example.com along the X axis , it only shows organisation.co.uk and you cannot see the name of the caller, the name is lost in the format of the graph So it becomes less useful when someone else uses the dashboard as they cannot see the name.
Oct 30 2019 09:53 AM
1. use Azure Monitor Workbooks (using the same query) or ,
2. remove the ending of the data e.g. remove anything after the @ symbol
AzureActivity | where Caller has "@" | extend CallerName = trim(@"[^\w]+",tostring(split(Caller,"@",0))) | summarize count() by bin(TimeGenerated, 1h), tostring(CallerName)