Forum Discussion

joergha's avatar
joergha
Copper Contributor
Jun 22, 2019

Barchart ignoring one data series

The following query    Heartbeat | where TimeGenerated >= startofday(ago(2d)) | where Computer == "ADMIN-PC" or Computer == "SERVER-PC" | summarize dcount(Computer) by t = endofday(TimeGenerat...
azure monitor
View Designer
joergha's avatar
joergha
Copper Contributor
Jun 24, 2019

CliveWatson 

 

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

 

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

  • joergha's avatar
    joergha
    Copper Contributor
    Jun 26, 2019

    CliveWatson 

     

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

     

    [https://dataexplorer.azure.com/clusters/help/databases/Samples?query=H4sIAAAAAAAAA5WRQUsDMRCFzxb6Hx49JbAr22oLWVhBahEPitTiRTykm9ENbbKSZikr/nizlVX3UFszYQ7DfG8eM0r6EMs1sYU2dE2WnPSkUhWyD5UI09K8VZ5cio132r5yoN9D857aJjZKhiJOJvFovEiG6ViEfyqE4NHgYTZ/nM3j++kgOvkGcQR4eXV7c9dyf6Ln+9EG+B/7yy8O0mf7aTz3ex/YFuQInc3iIguLlM6XL0rW7KAob3Q2lTHS6XeCysvKetYehWNZwyMDWfUl2BnG8XO/nU7p/I7oll2gySEv15WxeRHMYat9AYaVtioLdvMVqQi10TbMSvgnE3WBBTYCAAA=] [https://dataexplorer.azure.com/clusters/help/databases/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:

     

    Running the same query in log analytics results in this:

     

    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

Resources