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.