Log Analytics Views pinned on Dashboard are too restricted

%3CLINGO-SUB%20id%3D%22lingo-sub-966021%22%20slang%3D%22en-US%22%3ELog%20Analytics%20Views%20pinned%20on%20Dashboard%20are%20too%20restricted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-966021%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20pin%20a%20query%20to%20a%20Dashboard%2C%20such%20as%20a%20graph%2C%20I%20find%20that%20the%20X%20axis%20of%20the%20graph%20does%20not%20display%20correctly.%26nbsp%3B%20It%20shrinks%20the%20view%20of%20the%20labels%20on%20the%20X%20axis%20%2C%20even%20if%20you%20make%20it%20as%20big%20as%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20have%20a%20query%20for%20activity%20per%20user%20over%20a%20period%20of%20time.%26nbsp%3B%20It%20lists%20the%20'Caller'%26nbsp%3B%3CEM%3Ename%40myorganisation.co.uk%20%3C%2FEM%3Ealong%20the%20X%20axis%20%2C%20it%20only%20shows%26nbsp%3B%26nbsp%3B%3CEM%3Eorganisation.co.uk%26nbsp%3B%3C%2FEM%3Eand%20you%20cannot%20see%20the%20name%20of%20the%20caller%2C%20the%20name%20is%20lost%20in%20the%20format%20of%20the%20graph%26nbsp%3B%20%26nbsp%3BSo%20it%20becomes%20less%20useful%20when%20someone%20else%20uses%20the%20dashboard%20as%20they%20cannot%20see%20the%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-966021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-966175%22%20slang%3D%22en-US%22%3ERe%3A%20Log%20Analytics%20Views%20pinned%20on%20Dashboard%20are%20too%20restricted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-966175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F436486%22%20target%3D%22_blank%22%3E%40Steve_Aston%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETwo%20ideas.%3C%2FP%3E%0A%3CP%3E1.%20use%20Azure%20Monitor%20Workbooks%20(using%20the%20same%20query)%20or%20%2C%3C%2FP%3E%0A%3CP%3E2.%20remove%20the%20ending%20of%20the%20data%20e.g.%20remove%20anything%20after%20the%26nbsp%3B%40%20symbol%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3EAzureActivity%0A%7C%20where%20Caller%20has%20%22%40%22%0A%7C%20extend%20CallerName%20%3D%20trim(%40%22%5B%5E%5Cw%5D%2B%22%2Ctostring(split(Caller%2C%22%40%22%2C0)))%0A%7C%20summarize%20count()%20by%20bin(TimeGenerated%2C%201h)%2C%20tostring(CallerName)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fms.portal.azure.com%23%4072f988bf-86f1-41af-91ab-2d7cd011db47%2Fblade%2FMicrosoft_Azure_Monitoring_Logs%2FDemoLogsBlade%2FresourceId%2F%252FDemo%2Fsource%2FLogsBlade.AnalyticsShareLinkToQuery%2Fq%2FH4sIAAAAAAAAA0WNzQrCMBCE74LvsOSUYA76AEKLB2%25252BevPkDabuYhSaVzcba4sPbouj1m5lvyjEzlrXQg2RYLl7Qe2SEnWtbZPAugSrUzPEpGJtvcHABYQvCFHShTtdzf1kpK12aSLzpdG9J9Kdqp71dG2NmScohOKYRoe5yFG2gGqCiqI8UcI8R2Qk2FjbeWPjp%25252Fp%25252FmDVPGgZSvAAAA%2Ftimespan%2FP1D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EGo%20to%20Log%20Analytics%20and%20Run%20Query%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F152008iF0181008BEEC2B02%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1025542%22%20slang%3D%22en-US%22%3ERe%3A%20Log%20Analytics%20Views%20pinned%20on%20Dashboard%20are%20too%20restricted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1025542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Clive%2C%20I%20used%20your%20query%20and%20this%20has%20worked%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello

 

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' name@myorganisation.co.uk 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.

2 Replies

@Steve_Aston 

 

Two ideas.

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)

Go to Log Analytics and Run Query

clipboard_image_0.png

 

@Clive Watson

 

Thanks Clive, I used your query and this has worked for me.