This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 7.000000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Good day all I hope this message finds you well.
For my question today, I would like to know if it is possible to add a clickable bar in an Azure Workbook through our Azure log analytics workspaces that allows to view the
Avg
Min
Max
50th Percentile
95th Percentile
and so on, I think this would really help us a lot because we are always manually creating workbooks where we summarize and aggregate the avg|min|max etc and a clickable bar at the top similar to what we see in Insight Analytics would be fantastic
. I tried looking at a few options in the chart and column settings in a couple workbooks to try and create links to this but I didn't see the option there or even know what you would call this clickable bar.
Thank you in advance!
Hi, yes that makes it clear...
Step 1, set up a parameter and add the queries to match the display values, using an 'Options group':
Step 2:
Use the output in the chart query
Hi, to enable a selectable chart (I'm using bar chart as an example), you need to allow the fields to be exported, such as the X axis shown here when they are clicked on.
Also I'm not sure I recognise the workbook you are naming, where is that from?
You can then use that exported parameter elsewhere in your workbook, a top tip here is to set it up so that the new data is only shown (conditionally visible) if a Item on the chart has been selected. Like this:
Then you can use that exported value, in other parts of the workbook (this is just a demo use):
Thank you for response but I'm afraid I wasn't being very clear.
This is the bar I was meaning to add to workbooks, can this be done? (see image below).
It's what can be seen from some screens in Application Insights and I think some other areas but I never found these in workbooks but we code them manually to appear in grids and charts. Something like this at the top of a workbook would be amazing.
Many thanks.
Sorry I wasn't clear about this in my previous message. See image below, this is the bar I am speaking of.
Hope this helps explain it better
Thank you, so the only way is to build the queries within the parameter block of code? well it works but I can imagine that would be clunky for complex queries.
Much appreciated.