Home

Barchart ignoring one data series

%3CLINGO-SUB%20id%3D%22lingo-sub-715311%22%20slang%3D%22en-US%22%3EBarchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715311%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CSPAN%3EThe%20following%20query%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EHeartbeat%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%3D%20startofday(ago(%3C%2FSPAN%3E%3CSPAN%3E2%3C%2FSPAN%3E%3CSPAN%3Ed))%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22ADMIN-PC%22%3C%2FSPAN%3E%20%3CSPAN%3Eor%3C%2FSPAN%3E%3CSPAN%3E%20Computer%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22SERVER-PC%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20dcount(Computer)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20t%20%3D%20endofday(TimeGenerated)%20%2C%20Computer%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esort%3C%2FSPAN%3E%20%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20t%2C%20Computer%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20barchart%20kind%3Ddefault%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Eproduces%20the%20following%20table%20of%206%20record%20in%20two%20sets%3A%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20541px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120340i9A64F6B3F985DF98%2Fimage-dimensions%2F541x225%3Fv%3D1.0%22%20width%3D%22541%22%20height%3D%22225%22%20alt%3D%22Table.JPG%22%20title%3D%22Table.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EI'd%20expect%20to%20see%20a%20barchart%20with%20two%20series%2C%20but%20the%20result%20only%20shows%20one%3A%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20542px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120341i45E9BE552575B802%2Fimage-dimensions%2F542x373%3Fv%3D1.0%22%20width%3D%22542%22%20height%3D%22373%22%20alt%3D%22Barchart.JPG%22%20title%3D%22Barchart.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThe%20behavour%20is%20consistent.%20When%20I%20chose%20three%20series%20only%20two%20will%20be%20displayed.%20Do%20I%20miss%20anything%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3ERegards%20J%C3%B6rg%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-715311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EView%20Designer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716044%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716044%22%20slang%3D%22en-US%22%3EWouldn't%20you%20show%20it%20as%20'unstacked'%3F%20e.g%20change%20the%20last%20line%20to%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%7C%20render%20barchart%20kind%3Dunstacked%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716158%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716158%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethx%20for%20the%20reply!%20When%20changing%20on%20unstacked%20everything%20looks%20fine.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20387px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120414iBBC29E68CBC36324%2Fimage-dimensions%2F387x268%3Fv%3D1.0%22%20width%3D%22387%22%20height%3D%22268%22%20alt%3D%22Barchart.JPG%22%20title%3D%22Barchart.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dived%20a%20little%20more%20into%20the%20previous%20stacked%20barchart%20diagramm.%20There%20the%20Y-scale%20starts%20at%201.%20That%20might%20be%20the%20reason%20one%20series%20doesn't%20seem%20to%20show%20up.%20In%20my%20opinion%20for%20a%20stacked%20barchart%20diagram%20the%20Y-scale%20always%20must%20start%20at%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%20Joergs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716170%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716170%22%20slang%3D%22en-US%22%3EYou%20can%20use%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fkusto%2Fquery%2Fmake-seriesoperator%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fkusto%2Fquery%2Fmake-seriesoperator%3C%2FA%3E%20to%20backfill%20the%20required%200s%20(zeros).%20Have%20a%20look%2C%20when%20I%20have%20some%20time%20later%20I'll%20see%20if%20I%20have%20an%20example%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721868%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721868%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20simplyfied%20the%20qurey%20so%20it%20can%20be%20executed%20in%20Azure%20Data%20Explorer%20and%20in%20Azure%20Log%20analytics%20workspace.%20The%20query%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%5B%3CA%20href%3D%22https%3A%2F%2Fdataexplorer.azure.com%2Fclusters%2Fhelp%2Fdatabases%2FSamples%3Fquery%3DH4sIAAAAAAAAA5WRQUsDMRCFzxb6Hx49JbAr22oLWVhBahEPitTiRTykm9ENbbKSZikr%2FnizlVX3UFszYQ7DfG8eM0r6EMs1sYU2dE2WnPSkUhWyD5UI09K8VZ5cio132r5yoN9D857aJjZKhiJOJvFovEiG6ViEfyqE4NHgYTZ%2FnM3j%2B%2BkgOvkGcQR4eXV7c9dyf6Ln%2B9EG%2BB%2F7yy8O0mf7aTz3ex%2FYFuQInc3iIguLlM6XL0rW7KAob3Q2lTHS6XeCysvKetYehWNZwyMDWfUl2BnG8XO%2FnU7p%2FI7oll2gySEv15WxeRHMYat9AYaVtioLdvMVqQi10TbMSvgnE3WBBTYCAAA%3D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExecute%20Query%3C%2FA%3E%5D%20%5B%3CA%20href%3D%22https%3A%2F%2Fdataexplorer.azure.com%2Fclusters%2Fhelp%2Fdatabases%2FSamples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ecluster('help.kusto.windows.net').database('Samples')%3C%2FA%3E%5D%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Edatatable(TimeGenerated%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E%2C%20Computer%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%20%3CSPAN%3Estring%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%5B%3C%2FSPAN%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E25%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3CSPAN%3E%22SERVER-PC%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E25%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3CSPAN%3E%22ADMIN-PC%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E24%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3CSPAN%3E%22ADMIN-PC%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E24%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3CSPAN%3E%22SERVER-PC%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E23%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E)%2C%3C%2FSPAN%3E%3CSPAN%3E%22SERVER-PC%22%3C%2FSPAN%3E%3CSPAN%3E%20%5D%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%3D%20startofday(%3C%2FSPAN%3E%3CSPAN%3Edatetime%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E2019%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E06%3C%2FSPAN%3E%3CSPAN%3E-%3C%2FSPAN%3E%3CSPAN%3E23%3C%2FSPAN%3E%3CSPAN%3ET01%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E59.999%3C%2FSPAN%3E%3CSPAN%3E))%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20dcount(Computer)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20t%20%3D%20endofday(TimeGenerated)%20%2C%20Computer%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esort%3C%2FSPAN%3E%20%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20t%2C%20Computer%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Erender%3C%2FSPAN%3E%3CSPAN%3E%20columnchart%20with%20(%20kind%3Dstacked%2C%20ymin%20%3D%20%3C%2FSPAN%3E%3CSPAN%3E0%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSPAN%3EWhen%20executing%20in%20Azure%20data%20explorer%20the%20result%20renders%20correctly%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20646px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120698i8658E1F5448748F1%2Fimage-dimensions%2F646x246%3Fv%3D1.0%22%20width%3D%22646%22%20height%3D%22246%22%20alt%3D%22BarchartA.JPG%22%20title%3D%22BarchartA.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CIMG%20border%3D%220%22%20width%3D%22557%22%20height%3D%22216%22%20%2F%3E%3C%2FP%3E%3CP%3ERunning%20the%20same%20query%20in%20log%20analytics%20results%20in%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20632px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120697i3ED2654854E0F696%2Fimage-dimensions%2F632x307%3Fv%3D1.0%22%20width%3D%22632%22%20height%3D%22307%22%20alt%3D%22Barchart.JPG%22%20title%3D%22Barchart.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20mentinoed%20befort%20the%20Server-PC%20series%20is%20not%20displayed.%20I%20suppose%20that%20is%20because%20of%20the%20y-scale%20starts%20at%201.%20It%20seems%20when%20one%20series%20is%20contained%20in%20all%20colums%2C%20the%20scaling%20mechanism%20starts%20above.%20The%20ymin%20parameter%20is%20ignored.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EJ%C3%B6rg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721877%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F296428%22%20target%3D%22_blank%22%3E%40joergha%3C%2FA%3E%26nbsp%3BPlease%20remember%20Log%20Analytics%20is%20a%20subset%20of%20ADX%2C%20so%20some%20things%20are%20not%20available%20in%20both%20-%20like%20the%20Y-axis%2C%26nbsp%3B%20please%20see%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Flog-query%2Flog-query-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Flog-query%2Flog-query-overview%3C%2FA%3E%26nbsp%3Band%20especially%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Flog-query%2Fdata-explorer-difference%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Flog-query%2Fdata-explorer-difference%3C%2FA%3E%26nbsp%3B%20-%20however%20I%20will%20coincide%20its%20not%20a%20full%20list.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722021%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722021%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FDemo%3Fq%3DH4sIAAAAAAAAA3WPQQ6CQAxF9yTcoXEFiSgSt%252BPGhR7ACxSmClFa7QwSEg%252FvkEiIJnbzm%252FS1%252F%252FdIqL4k9HG0Xr%252Bgr0kJTk1LB2JS9GRhZ8D5QMnZ4pDgRZLCpmkcTfRe2nvnScEYWLjHzZE%252BSbN8VQl7cRK0XYDoP3DzBY53W7xSFqYNObCVdOyTaTcFS2fsbt7kEEcwl%252FBP7IZBkS80JV4CS58EKbZ1CuUwxxktldiGtkSt6vArXBu25mMVR2%252FGOug3JgEAAA%253D%253D%26amp%3Btimespan%3DP1D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGo%20to%20Log%20Analytics%20and%20Run%20Query%3C%2FA%3E%26nbsp%3B-%20would%20this%20work%20for%20you%20(only%20in%20Log%20Analytics)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722118%22%20slang%3D%22en-US%22%3ERe%3A%20Barchart%20ignoring%20one%20data%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722118%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewould%20work!%20Thanks%20a%20lot!%3C%2FP%3E%3C%2FLINGO-BODY%3E
joergha
New Contributor
The following query 
 
Heartbeat
| where TimeGenerated >= startofday(ago(2d))
| where Computer == "ADMIN-PC" or Computer == "SERVER-PC"
| summarize dcount(Computer) by t = endofday(TimeGenerated) , Computer
| sort by t, Computer
| render barchart kind=default
 
produces the following table of 6 record in two sets:
 
Table.JPG
I'd expect to see a barchart with two series, but the result only shows one:
 
Barchart.JPG
 
The behavour is consistent. When I chose three series only two will be displayed. Do I miss anything?
 
Regards Jörg
 
7 Replies
Wouldn't you show it as 'unstacked'? e.g change the last line to:

| render barchart kind=unstacked

@Clive Watson 

 

thx for the reply! When changing on unstacked everything looks fine.

Barchart.JPG

 

I dived a little more into the previous stacked barchart diagramm. There the Y-scale starts at 1. That might be the reason one series doesn't seem to show up. In my opinion for a stacked barchart diagram the Y-scale always must start at 0.

 

Regards Joergs

You can use https://docs.microsoft.com/en-us/azure/kusto/query/make-seriesoperator to backfill the required 0s (zeros). Have a look, when I have some time later I'll see if I have an example

@Clive Watson 

 

I simplyfied the qurey so it can be executed in Azure Data Explorer and in Azure Log analytics workspace. The query is:

 

[Execute Query] [cluster('help.kusto.windows.net').database('Samples')]

datatable(TimeGenerated:datetime, Computer: string)
[datetime(2019-06-25T01:59:59.999),"SERVER-PC",  
datetime(2019-06-25T01:59:59.999),"ADMIN-PC",        
datetime(2019-06-24T01:59:59.999),"ADMIN-PC",      
datetime(2019-06-24T01:59:59.999),"SERVER-PC",    
datetime(2019-06-23T01:59:59.999),"SERVER-PC" ]
| where TimeGenerated >= startofday(datetime(2019-06-23T01:59:59.999))
| summarize dcount(Computer) by t = endofday(TimeGenerated) , Computer
| sort by t, Computer
| render columnchart with ( kind=stacked, ymin = 0)
 

When executing in Azure data explorer the result renders correctly:

BarchartA.JPG

 

Running the same query in log analytics results in this:

Barchart.JPG

 

As mentinoed befort the Server-PC series is not displayed. I suppose that is because of the y-scale starts at 1. It seems when one series is contained in all colums, the scaling mechanism starts above. The ymin parameter is ignored.

 

Regards

Jörg

@joergha Please remember Log Analytics is a subset of ADX, so some things are not available in both - like the Y-axis,  please see:

 

https://docs.microsoft.com/en-gb/azure/azure-monitor/log-query/log-query-overview and especially https://docs.microsoft.com/en-gb/azure/azure-monitor/log-query/data-explorer-difference  - however I will coincide its not a full list.  

Go to Log Analytics and Run Query - would this work for you (only in Log Analytics) ?

@Clive Watson 

 

would work! Thanks a lot!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies