Forum Discussion

Microsoft

Jul 05, 2019

barchart Ignoring the ymin and ymax values

I know there is an open post but even that isn't closed. Along with these params many other properties also doesn't seem to work. e.g. legend My query : AzureDiagnostics | where replicati...

azure monitor

Query Language

CliveWatson

Silver Contributor

Jul 05, 2019

hsaini007

Would this help?

AzureDiagnostics
    | where replicationProviderName_s == "A2A"
    | where isnotempty(name_s) and isnotnull(name_s)
    | extend RPO = case(
            rpoInSeconds_d <= 100,  "<15Min",
            rpoInSeconds_d <= 1000, "15-30Min",
                                    ">30Min")
    | summarize hint.strategy=partitioned arg_max(TimeGenerated, *) by name_s
    | project comp_list = name_s , RPO
    | summarize count(comp_list) by RPO, comp_list
| render barchart kind=stacked

hsaini007
Microsoft
Jul 08, 2019
CliveWatson : thanks for your reply but the output is still not as expected.

Elaborating the context here, I am trying to group the occurences based on time range showing the count of occurrences per range.

E.g. How many vm's have RPO time <15 min, how many between 15-30min and rest.

The output of the updated query looks below. unstacking just result in a bar of height 1.
- CliveWatson
  Silver Contributor
  Jul 08, 2019
  hsaini007
  
  If its just a count, wouldn't this be enough?
  
  AzureDiagnostics | where replicationProviderName_s == "A2A" | where isnotempty(name_s) and isnotnull(name_s) | extend RPO = case( rpoInSeconds_d <= 100, "<15Min", rpoInSeconds_d <= 500, "15-30Min", ">30Min") | summarize count() by RPO , name_s | render barchart
  
  or (hide the name_s)
  
  Go to Log Analytics and Run Query
  - hsaini007
    Microsoft
    Jul 08, 2019
    Hey CliveWatson : The problem remains the same. due to yMin not being set to 0 I can never see the bar for the third range.