Original subtitles

So in the previous lesson, we saw how we could use slices.

I'm actually just going to delete these slices just to reset the data.

But we did see that we were able to use text fields, we were able to use numeric fields, and we were

able to use data fields to be able to easily filter the data that was being shown for all the visualizations.

Now, the other type of filter that we can do is to be able to actually filter within a visualization

itself.

So this is really useful when you want to be able to take a specific visualization and you only want

to show specific data within that.

So let's look at some examples.

I'm going to create a new page and we're going to go back to using our table.

And what we're going to do is we're actually going to use our country and sales.

So let's pop our country in sales into this.

So we've got quite a few countries in here with varying amounts of sales.

Now, what we are going to do is we're actually going to open up our filters box.

So what happens here is that our visualization is selected and it actually now allows us to use the

filters within this visualization.

So you can see that the first part is that we've got the filters on this visualization.

So your fields that are in the visualization are automatically added into this filters.

So we currently got our countries.

So let's have a look at this, expand this a little bit.

And the first type of filtering we can do is basic filtering.

So let's say, for example, you just wanted a list of specific countries you could just go through

here and manually select then the countries that you want to choose.

So basically, just like you would with an Excel filter, just basically come in here, select the countries,

and you can see now that we now have our filtered list and it only shows us a total for those items

that have been selected.

So that's the first type of filter that you can do is basic filtering.

The next type of filtering is the ability to be able to do advanced filtering.

So let's say that we actually I'm going to just clear off previous one so you'll see that there's a

little clear button filter.

So there we go.

We've got advanced filtering now, so basically we can say advanced filtering share items when the value

is and you can say contain something starts with something is something is not.

So let's say, for example, we want to find all the countries that start with the letter I.

So I'm going to say it starts with and I'm going to say the letter I.

Now, once I've got this, I can click on the apply filter button and you see straight away now we're

showing that there's four countries that start with the letter I.

Now, you may want to say, for example, combine this with other ones so you can use your end in or

logic.

So let's say or we want to find all countries that start with, say, a U, but a U in there and apply

the filter.

And you can see now that we've got two countries that start with you.

So you can use this to for your advanced filtering when you want to be able to find something that starts

with something, contain something, and you can see there's a bit more operators there as well, such

as is not is blank, is not blank as well, depending on what you would want to filter.

So that's the advanced filtering that you can use.

Again, let's just clear this.

And the last type of faltering is your top end filtering.

So you may want to see, for example, the top ten countries or the bottom ten countries.

So this is really useful when you're wanting a list and you just want to say, I want to see the top

ten countries for this.

So you say Top End and you'll see now that our filter would say to show items top or bottom, we go

to this, see, top or bottom.

So let's say we want the top ten countries.

So I'm going to say top ten countries.

Now, what it will ask you is by which value.

So it does mean that you could use another value besides sales.

So you could use profit, for example, if you wanted to.

But I'm going to use sales because it just makes most sense to be able to use sales.

And we're going to say a filter.

And you can see now it's now taking my top ten countries shows me the total for those.

Again, if I wanted to see these by the value can actually just change my sort order for the sum of

sales.

If I wanted to see the, say, the bottom ten.

Supply the filter.

And there we go.

There's my bottom ten countries.

So really useful to have your top end.

You can find the top ten, top five, top 15 if you wanted to.

Countries by that and again, if you wanted to clear your filter, just select that and then that will

clear that filter away.

Now, let's say, for example, that you wanted to actually use a numeric.

So in this case we wanted to see how many countries did we have sales that were, say, less than 500,000.

So in this case, we wouldn't be using our country field, We would move to our sales field.

So let's expand this and you'll see.

Now my filter options is the ability to find things that are less than something is greater than something

is something or is not something.

So in this case, let's say I want to find all countries that have got sales is less than or equal to.

And in this case it's going to be 500,000, let's say 500,000 there.

I'm going to apply the filter.

I can see I've got quite a long list of countries.

Now, question would come, how do I know how many countries?

So one of the tricks I could use for this is if I go back to my visualization and go back to my columns,

if I was to get another copy of my country and just drop it into my table.

And now I say that I want to do a distinct count.

What it will do is it lets you just count the country once.

So now it will show me a list of all the countries and it will actually show me that I've got 25 countries

that have sales, less than 500,000.

So that's just a little trick you can use when you want to do accounting.

You want to know how many of something are contributing.

Let's say, for example, I wanted to know how many countries had sales greater than a million.

So let's just change that.

Let's say is greater than or equal to and in this case, let's say a million.

And we click apply filter on that.

And there we go.

We can see that the six countries that have got sales greater than a million, we could use our end

on all logic on this as well.

So you could say that you want to find all how many countries have sales?

Between 500,000 and a million.

So in this case, we want to be saying is less than or greater to than or equal to a million and is

greater than or equal to 500,000.

Just try that logic.

I got the number of zeros correct.

Apply filter.

And there we go.

We find three countries that are between the values of a million and 500,000.

So this is just one thing where you could use your numeric filters, is that you could ask for something

that is less than or equal to a specific value.

Now we're just going to clear this, so we're just going to move it away.

Now, what you do get the ability to do is actually to be able to add fields into your filter.

So let's say, for example, we wanted to know what was the sales for each country, but only for the

audio product category.

So what we could do is we could take the audio product category, just drop the product category into

there here, and then we could select just audio and you'll see automatically now that my sales has

been filtered only to show the audio product category.

So as you can see, this becomes really powerful where you can actually add as many fields as you wanted

to in here to create any combination of the filters that you want to use.

Now, we're going to keep this pretty simple.

We're just going to show that as an example.

But you can imagine you could bring in a region for this or you could bring in a channel and you could

use those as specific filters.

If I wanted to change this to cell phones, as you can see, very easy to do.

But again, I'm going to just clear the filter.

Now, one thing to note is that this field is not part of my table, but it does allow me to do is actually

remove this from the filters.

It will not allow you, though, to remove a field that is actually part of the table.

And the last one that I wanted to go over was just the data filters that we use just now.

So just now in our slicer, we used all ordered data and we saw that there were two types of filters

that we could use.

We could use a basic filtering or we could use a relative data filtering.

Now, in this case, actually a basic filtering means that you actually just pick the independent dates.

Rather, when I was speaking about a basic filtering, I was meaning more on the advanced filtering

where we say something is on or after a specific date is on or before a specific date.

So let's say we want to find all the sales that is on or after and let's say the day and the month.

So let's say we want to start with the 0107 and let's say it's 2013 and we want to find actually, let's

just apply the filter on that so we can see automatically now that everything that is on and after right

to the end of the dataset is now filtered to, to display that.

But you could combine this and you could say that I want to see and is on or before.

And in this case we would need a date that is later.

So that's the first of the ninth 2013.

So you can enter the dates that you would want in here and click apply filter and there we go.

It's now showing you the filter data for those two dates.

What you could also show is that you could have your relative date here as well.

So you could say, I want to show a relative date and you could say that it is in the last and let's

say seven days.

Remember, we're not going to see any data because the data is too old.

But you could say, as in the last seven days or you could say is in the last seven weeks, or you could

say is in the last seven months and so on.

So it's very easy to be able to change these to either relative or to a normal date range that you would

want to use within your filters.

Again, please note that the ordered data is not part of the actual table here.

This could actually remove it.

So there we go.

That's the first part that I wanted to show you was the visual filters and just the ability to be able

to add the filters to a table.

As you can see quite a lot that we can do there.

We're going to conclude the lesson there.

I will see you in the next one.