OK so we have seen how to add visuals and I-Report or to add filtering on them.
Now let's learn one of the most important part of our which is drilling down so drilling down in visually
ordinary important means to go in depth of that particular visual to know more about that region.
So suppose let's say this barge out of ours.
So it is right now having customer name and as well.
Now suppose our requirement is we want to know which country that from that are from that our customers
belongs to.
OK.
So we'll add this country on top of the customer name.
So now this is what it is showing that sales are showing on the basis of the country.
Let me do it in Australia France Singapore and U.K. and now we want to know which country countries
are having our customers.
So to do that we have these we have these big smart buttons that idea these buttons I need to know about
each and every one of them.
So first of all this Barberton this issue is the next higher.
The next time means our NSIDC country customer name.
So when we click on that nowaday showing the customer name or what our customers names from all the
countries suppose there are four or five hierarchies up here.
So it is one by one go to the next hierarchy's Don let's button up here is expand on one level in the
hierarchy or all down to one level.
So what it will show is that when you click on it it will let you know for all the hierarchies from
that particular how to get stuff for both your first hire give us country.
So it really shows you the country name right here and it will show you which countries having which
customer.
So Spain is having you know shopping us is having many gifts are still having Australian collectors.
So it will ex-Foreign all of them.
And so all of them together but this one will just go to the next level.
This is a difference between these two but we don't support our requirement is different we just want
to see the customers or any of us.
But I know what it is showing is showing us all the customers of all the different countries.
We wanted to see just this particular box OK to afford to do that.
We have to click on this button.
This is the shores kneeling down.
When we click on this this will activate and now when we click on USA just like this it will get down
to the various customers it is having.
One thing to note is that all of the other charges have also been turned on the value on the basis of
what we have played.
So you have clicked on to USA.
So it is showing values of only us in the price and quantity of USA sales offer us as you can see here
us here.
We can go read by clicking on this when you click on Spain it will show you the values of Spain customers.
So this is how you drill down in any of the visual.
So this is not only possible in this bars started only very down in many other visuals.
So as I said many other regions because not in our business we can break down but in many of those when
you click on this pie chart it will also show you how to do so.
As you can see all these countries when you click on any country it will show you the values of our
customers just like this.
When you go up it could show you various customers that this is really very very important part of our
way to know how to drill down effectively.
So there are these two different ways of dealing Don.
First is this to go to the next level to drill down or what are together with the full total visual
total number of things which we are having.
And the final is to drill down to our particular data point down.
I hope you have understood this if you have any questions feel free to ask me in the query sections
any time.