Home

Sorting The Legend in a Timechart

%3CLINGO-SUB%20id%3D%22lingo-sub-784801%22%20slang%3D%22en-US%22%3ESorting%20The%20Legend%20in%20a%20Timechart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784801%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20folks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20just%20getting%20started%20with%20this.%20Using%20Log%20Analytics%20and%20kusto%20queries%2C%20I%20have%20created%20a%20simple%20dashboard%20with%20several%20panels.%20Each%20panel%20displays%20a%20timechart%20showing%20the%20aggregate%20values%20for%20a%20single%20Performance%20Counter%2C%20for%20several%20machines.%20The%20machine%20names%20are%20displayed%20in%20legend%20at%20the%20right%20of%20the%20chart%2C%20each%20name%20coded%20with%20a%20color%20that%20matches%20the%20color%20of%20the%20corresponding%20line%20in%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I'm%20having%20is%20sorting%20this%20legend%20of%20machine%20names.%20When%20I%20render%20the%20chart%20in%20the%20kusto%20query%20editor%2C%20the%20names%20are%26nbsp%3B%3CEM%3Ealways%26nbsp%3B%3C%2FEM%3Esorted%20alphabetically.%20However%2C%20when%20I%20add%20them%20to%20a%20shared%20dashboard%2C%20the%20names%20sort%20randomly.%20The%20result%20is%20that%20the%20same%20machine%20gets%20assigned%20a%20different%20color%20in%20different%20panels.%20I%20would%20like%20to%20sort%20them%20consistently%2C%20which%20should%20make%20it%20so%20that%20Computer01%20is%20the%20light%20blue%20line%20in%20all%20panels%2C%20Computer02%20is%20the%20red%20line%20in%20all%20panels%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20how%20this%20can%20be%20accomplished%3F%20I've%20tried%20using%20an%20order%20by%20in%20the%20kusto%20query%2C%20but%20as%20soon%20as%20I%20pin%20the%20query%20to%20a%20dashboard%2C%20the%20sorting%20is%20random%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20you%20can%20provide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-784801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
DylanBragg
Regular Visitor

Hi folks, 

 

I am just getting started with this. Using Log Analytics and kusto queries, I have created a simple dashboard with several panels. Each panel displays a timechart showing the aggregate values for a single Performance Counter, for several machines. The machine names are displayed in legend at the right of the chart, each name coded with a color that matches the color of the corresponding line in the chart.

 

The problem I'm having is sorting this legend of machine names. When I render the chart in the kusto query editor, the names are always sorted alphabetically. However, when I add them to a shared dashboard, the names sort randomly. The result is that the same machine gets assigned a different color in different panels. I would like to sort them consistently, which should make it so that Computer01 is the light blue line in all panels, Computer02 is the red line in all panels, etc. 

 

Any idea how this can be accomplished? I've tried using an order by in the kusto query, but as soon as I pin the query to a dashboard, the sorting is random again.

 

Thanks for any help you can provide.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies