>> Hello there and thank you very much for joining us
today in this new Azure Portal How-To Video. Today we'll
learn how to organize and structure you workbooks. And
for that we have Shikha Jain, who’s going to show us how
to do that. So, thank you very
much for joining us today, Shikha.
>> Thanks, Leon, for having me over again. And in the
previous sessions, we've talked about how to build
different visuals. And today I'm going to talk to you about
how to use tabs, groups, and parameters to enhance your
workbooks and create more and more complex stories.
>> That sounds great. Let's go to it.
>> So continuing on from the last video we did where we
built a workbook using availability data like help from
Azure Monitor and Azure Resource Graph, so today what
we're going to do is we're going to bring more organization
to this workbook. By organization, I mean most of the
times in the reports you see different segments of reports.
So, here I'm going to create something what we call as
links in tabs. So, we're going to add more tabs here. And
there are multiple options to display things as links or just
bulleted list, but we're going to use tabs the traditional
way of doing it. And we're going to give it display name
that your users of the workbook are going to see. And the
way I'm going to use it is using, setting this as a
parameter value so that I can reference it later. And I'm
going to give the value for the parameter name. Let's add
few more tabs here while we're here, and this is how you
can incrementally keep
building. I am going to reference
the same parameter and
set it a different value this time
for this particular tab. So once I've done this, you see how
here I've got two tabs I could have added more and allows
for segmentation. Now once I'm here, I just want to see
availability data.
Let's introduce you to another concept where we're going
to add something called Group, Now group, as the name
suggests, is a container of different controls. So, what I'm
going to do here is I'm going to connect this particular tab
to this group and then add more items into the group. In
order to connect the group and the tab, I'm going to first
give it a good name. Because
its availability, let's call that
here and this is the way to connect these things where I
say, this group should be
visible only when this condition is
met. And the condition is the parameter that I set for the
tab. It's called Selected Tab and then I can see the value
was as we set it to be, availability.
So once I do this, let's test it out what this means. Let's
add a control, text, let's say show only when selected.
When I do this, what would happen now is when I go to
alerts, you don't see that
control, that group that I added.
When you go to availability, you see this. So, it plays this
segmentation very well.
The next step could be since we had all these visual
controls for availability, let's move this into a group. This is
where the group feature really builds up. I'm moving all
my controls that were related to availability into my
availability group. And if you have more groups, it will have
a drop down selection of moving into different groups.
Right now I have only one group, but I also have the
ability to create new groups. So now if you notice, if I go
to alerts, nothing shows up. When I go to availability,
everything is there. So, this is how the group mechanism
works. So tabbing an grouping, that's the concept.
Now third concept I want to work on is let's start building
something around alerts. One of the tricks I usually use
as an editor is when I'm in the second tab, I don't want to
see those hidden elements. There could be multiple. I can
use this control which says only show visible items when
editing. So, anything that's contextual to this will show up.
We’ll follow the same
principle of adding a group here.
Naming it a qualified name and then making it
conditionally associating it with the tab again. And here
I'm using the same parameter name, but this time the
value is alert so that when the alerts tab is selected, this
group will display.
So, here what I'm going to do is with alerts, I'm going to
bring the data from Log Analytics and see what are the
alerts that are set up on my logs. So, we talked about
setting parameters in the previous session, where I can
select a subscription as a parameter. This time what we're
going to do is we're going to create a parameter for
workspaces. So, here I'll repeat this, I'll go and say add
parameter. And in workbook, everything works top to
down. So, this parameter since I want to use downwards,
I'm going to move up.
Now the parameter that I'm going to add, it's a workspace
selector, so give it a name, call it a resource picker
because I'm going to pick a resource, make it required,
and then I'm going to use Azure Resource Graph to bring
the list of all workspaces in the selected subscription.
Subscription was a parameter already. So, here I'm going
to create this parameter and then you see how for those
subscriptions, I get the workspaces. And I can select one
of those and save it. And this is the one that I can use
later on. I can also do one more thing. I can move it out of
the group and reference it later. The other parameter that
I'm also going to add, which is a standard one, is time
range. So, this is a standard time range picker and
doesn't require any queries and other things and provides
you multiple choices. You can select, deselect, whatever
you want and I can select
default to be my four hours’ time
window let's say.
So now that I have these parameters going, let's go and
build a query. In the Log Analytics now, instead of
selecting the list of workspaces, I'm going to use my
parameter. I'm going to use my time range parameter, and
I am now going to bring all the alerts data from this
analytics, saying give me all the alerts and grouped by
type here. So once I run this query,
oh, it happens sometimes. The time range is not set, so I
can go and select this to be 24 hours and now it's running
the query. It'll get me the data. We did talk about setting
it up as different visualization.
I'm going to select it as a
pie chart right now. And in the pie chart, I can also have
control of what I want this data to show up. So critical, I
don't want it to be blue. I can set it up to be red. So, now I
have this. I want to see the details of these errors. So,
let's go and either create a
different query or I can just use
clone to duplicate a resetting that I have here. And what
I'm going to do is I'm going to change this query. So for
the details, I have another
query. And let's pace that query,
and this time since it's going to be detail, I don't want pie
chart. Let's select a grid as the visualization and bring in
the data.
So, seems like the time range is set up.
Okay.
Sometimes [AUDIO] is,
so this is where I get the details of the data, and again I
can use some of the thresholds to change the alert value.
And here I can select go thresholds and I can use colors
and say, if the value is set
to critical, color code it as red.
So, you would see the
difference here. I see everything is
critical. The other thing that
also is possible is if let's say I
want to group everything by alert type, so I can use this
capability called group by. And I can say group by alert
time, and I can hide the alert type here so that it's not in
the data. And I get always go multiple tiering on the
grouping. So. this way what happens is now if you see I've
got the grouping here, so it’s showing me all the critical
errors. If there were different kind of errors, it would have
grouped under it.
So once I have done all of this, what would happen is your
workbook would look like this. So, I can now go critical
error and see all the critical errors here. But let's say if I
had changed this to a different - - now what is happening
is I'm seeing everything for error and everything for
critical, but I just want to say, okay, when I click here on
critical, I want to show, see only those errors. So, make it
contextual. In order to do that workbook support, that kind
of linking, so user selection can be passed on to the
downward data. Here, what I'm going to do is I'm going to
start editing it again. One of the things that I like to do is
fit them in, so let's make this 33%. And you could also say
how much of the screen size it should take. And I'm going
to say there is an option called when items are selected
export parameters, so when
I click on critical, it'll export
that parameter that I can use downwards in my grid. So,
this is a standard field to
export. Give it the name that you
want to use. And default is if nothing is selected, I'm just
saying select everything.
After I do this, so every time now
my parameter is set to critical instead of error. So, what
would happen is I will go and use this parameter
downwards in my query here. So here remember, I was
bringing the alert type and then I can add a clause saying
where alert type is equal to this parameter that I defined
on the top. So, either it could be this or it could be none of
that. So, let's run the query.
And when it's running the query, you see how it says you
selected error, so it's only showing me the error values.
So, another thing that I can do is I can place them side by
side. So, one final step to show you how to do this
placement is by, again, going to edit mode and going to
style, changing this. I set that to 33%, so let's make this
67%. And also, I want to show you one more thing. You
can in this style, in the control
for this particular grid, what
you can do is there are various options here and I want to
highlight few. So, you can set this button which will allow
you to export the data, you see onscreen to Excel. You can
also directly go to the query, so it will take you to the Log
Analytics, the query behind so that the user who's using it
doesn't have to go and edit more to find that out. And
also, there is an ability to pin this on the dashboard. So if I
select these three options, above the grid, you would see
these three coming up. So, you can export to Excel. You
can pin it to dashboard. If I click this, it shows me the
pin to dashboard, and I can go to Log Analytics query.
So, there you go. Now we
have availability data built-in, so
I only see the availability
information. When I go to alerts,
I only see alerts information. And here if you notice, when
I select critical, it's bringing critical information. When I
select error, it's bringing error information.
>> Thank you very much, Shikha. And thanks, every one
of you, for watching. Please just try this out, let us
know what you think. Leave us a comment in the comment
section, follow us on Twitter and look forward seeing you
in the next video. Thanks for watching.