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

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.