User Profile
the_irk
Copper Contributor
Joined Feb 22, 2019
User Widgets
Recent Discussions
Render operator ignoring ymin and ymax values
I'm having a problem with the analytics tools, specifically the Analytics inside Application Insights as well as the Logs analytics inside a Log Analytics workspace. Regardless of query or chart type, when I specify with(ymin=x, ymax=y) values to the render function those values are ignored. Example query: Heartbeat | summarize heartbeatPerHour = count() by bin_at(TimeGenerated, 1m, ago(30d)), Computer | extend availablePerHour = iff(heartbeatPerHour > 0, true, false) | summarize totalAvailableHours = countif(availablePerHour == true) by Computer | extend availabilityRate = totalAvailableHours*100.0/(1440 * 30) | extend MeetsSLA = availabilityRate > 99.9 | project Computer, availabilityRate | render barchart with(title="Last 30 Days Availability (DEMO)", ymin=0, ymax=100) In this particular case the expeced values are between 2-3% uptime because the system's only been logging for a day or so yet the query covers a month. The resulting graph has a range of 0-3 instead of the requested 0-100. There doesn't seem to be an "automatic range" option that I need to turn off; by all accounts including MS's documentation this should just work, yet it isn't. Result from example: I've tried this with queries from App Insights as well as a Log Analytics workspace, and across multiple browsers (FireFox, Chrome, IE, Edge). I know the render operator's documentation clearly states that some user agents might not support certain features, however this looks more like no user agents support this feature. Is there something I'm doing wrong, or need to do differently in order to make this work? Is this something that isn't currently implemented? Open to any advice or suggestions, thanks!Solved6.9KViews1like9CommentsRe: Render operator ignoring ymin and ymax values
CliveWatsonThanks for getting back to me; even this demo doesn't work on my data set- I get a graph from 90 to 112 across browsers. I suspect that the values are simply ignored; I can create a graph that looks like the demo, but only when I include a value near 0.6.3KViews0likes0Comments
Recent Blog Articles
No content to show