Tableau 2020.2 Set controls full built out example

0:00In Tableau 2020.2 Tableau have added the

0:02ability for sets to be controlled with

0:05filter-like

0:06controls. I'm going to start this video

0:08backwards by actually showing you the

0:09finished product of

0:10what we're going to build right from the

0:12beginning. So here we have a map of London

0:14and we're basically comparing the

0:16differences in averages across prices in

0:19different sort of post

0:20codes. Okay so the cool thing about this is

0:22it's got set actions already applied in the

0:25background

0:26so I'm actually going to show you two ways

0:28of doing the same thing. When I select this

0:30particular region you'll notice that the

0:32chart changes and that's because it's

0:34comparing the

0:35average price against the selection that I

0:38've made. So when I make a selection it

0:40changes the

0:41comparison point and when I click on it

0:43again it actually clears that selection

0:45then just compares

0:46it across the average of everything. Okay

0:49so this makes it really really interactive.

0:51I can actually

0:52sort of click on a particular part of

0:54London and see well how do house prices

0:56compare against this

0:58particular selection that I've made or this

1:01other one here in E6. And notice as I do

1:03that

1:04the selection I make gets a label. We've

1:06also got this information here in the

1:09tooltip. You'll

1:10notice the difference from the average is

1:12zero because this is actually comparing

1:14itself against

1:14itself so there is no difference. Yet if I

1:16go to the one above it you'll see there's a

1:18difference

1:19of 53 000 pounds. Okay now the other thing

1:22you'll notice is that I've actually got

1:24that difference

1:25in average up here so you can actually see

1:28that comparison straight up. Okay so you

1:31can actually

1:31see the average price for the selection in

1:34this tooltip so you actually know what you

1:37're working

1:37with. There's a lot of context here. Now

1:39the new feature in 2020.2 is the ability to

1:43control this

1:44using a filter like interface. You can see

1:46right here that E11 there and E11 are the

1:49same and I

1:49can actually go down in here and tick

1:51another selection and notice that the chart

1:54changes. Now

1:55this doesn't quite work as well because I

1:59've got a set action applied over here but

2:02the selection

2:02only shows the mouse selection so what I'd

2:05have to do for this to work is select

2:07several and then

2:08you'd see the regions apply but then those

2:10are also available here and you can sort of

2:12play

2:12around with them and see how they work.

2:15Okay so this is quite a complex bit of

2:17analysis we're

2:18doing and in order to build it we have to

2:20kind of start right from the basics by

2:22building the

2:23very basic chart. That's what I'm going to

2:25show you how to do next. So the first thing

2:27we need

2:28to do is obviously connect to the data

2:30source and basically start looking at our

2:32data. So I've

2:33actually got a CSV file that I'm going to

2:35be connecting to here it's just on my

2:37desktop.

2:39If I go to my desktop here go to 2020.2 you

2:42'll see that I've got this London house data

2:45available to

2:45me. Now this example is actually modified

2:49ever so slightly from the beta test

2:51scenario that we were

2:52asked to test to test this feature if that

2:54makes sense. So I've made it slightly

2:56simpler for the

2:58purpose of this tutorial but it's

2:59essentially the same data if you've been

3:01using the Tableau beta.

3:02Okay so let's go into the sheet and you'll

3:05see that we have our data sources here on

3:08the left

3:08hand side. For those of you wondering why I

3:10can't see dimensions and measures that's

3:13because in this

3:13version the data model has been rolled out

3:16so that slight distinction between

3:18dimensions and measures

3:19is now only really seen when you try and

3:22drag items between the two sections. You

3:26can see this

3:26very subtle line that does that sort of

3:28distinction. Okay so let's start building

3:31our chart and I'll

3:32sort of talk through the problem as I build

3:33this and I really sort of ask that you bear

3:35with me

3:35as I walk you through this because this can

3:37be a bit of a mind maze but we're going to

3:39get there

3:40and we'll build this chart. So I'm going to

3:42right click my data source and then I'm

3:44going to take

3:44an extract. The reason I'm doing this is

3:47because it makes the data source faster

3:49okay so it just

3:50makes working with this especially in a

3:52demo that I'm doing right now much much

3:54faster and I know

3:55it's an extract because if you see here you

3:57'll see these two cylinders and an arrow

3:59going between

4:00them that lets me know that it's a Tableau

4:02data extract it's actually using the hyper

4:05file format

4:06okay. Now the next thing we'd like to do is

4:08to just visualize the information that we

4:12have okay.

4:12This can be slightly sort of cumbersome

4:15because I'm dealing with spatial data and

4:17yet I have no

4:18real information here that's that sort of

4:20signals spatial information other than a

4:23postcode and a

4:24postcode area. So let me just double click

4:26these and just see what happens. You'll

4:28notice that

4:29there's obviously an issue there so that

4:31doesn't work it's not recognizing the post

4:33codes properly.

4:34So what I normally do is I try the other

4:36one that I have in my data set just to see

4:37if that

4:38sort of yields different results and if I

4:40double click that as well you'll see I also

4:42have the same

4:43issue okay. So I'm having a slight problem

4:45here just basically figuring out what's

4:48actually going

4:48on okay. Now what I need to do is I need to

4:51actually define that this out code if I

4:54just

4:55describe this field here you see this out

4:57code this is actually the spatial

4:59information that I

5:00want to work with. So I'm going to click

5:03close and I'm going to go right click on

5:05out code and I'm

5:05going to go to geographic role and I'm

5:07actually going to assign this a postcode

5:10okay and when I

5:11do that then double click that you'll see I

5:14now get the spatial information that I want

5:16. So just

5:17always bear with the data source sometimes

5:19it's not where you expect it to be and you

5:21might just

5:22need to do some work to make things work

5:24out. Now you can see dots here and that's

5:27great because it

5:28tells me exactly where the centroid of that

5:31particular postcode is but what I'd

5:33actually

5:33need to do is actually make a field map. So

5:36in order to do this there's one place to do

5:38this

5:38every single time and it's the marks card

5:40over here. So in the marks card if you

5:42select the drop

5:43down you'll see you get different chart

5:45types and actually we want Tableau to not

5:47use the automatic

5:48suggestion here which is a circle and

5:51instead use a map and when I change that

5:53you now see that we've

5:55got the out codes nicely sort of shaped out

5:57. This information is actually held inside

6:00of Tableau

6:01has something called a Firebird database

6:03that has all this information and that's

6:05where it's

6:06getting the spatial information to draw

6:08this detail onto the map. Now the next

6:11thing we

6:11probably need to do is just to style this a

6:13little bit before we move on it's easy to

6:15do it now rather

6:16than later so I'm going to go to the map

6:18layers at the very top by clicking on map

6:20and then going

6:20down to this second to last option. Now

6:23once we're there we can add some detail

6:25onto the map.

6:26I'm going to add streets because that

6:28always helps to give some point of context

6:30on a map and you can

6:32obviously you know be more fancy with these

6:34other map styles but I actually want to

6:36keep this fairly

6:37simple and what I'd like to do is add some

6:39context that's relevant to what we're

6:41looking at. So

6:42I'm going to add the postcode boundaries

6:45and the postcode labels so we can sort of

6:47get a sense of

6:48which postcodes are covered and which aren

6:51't covered in our analysis. The last change

6:54I'm

6:54going to make is by making the border of

6:56all each of these shapes white so I'm going

6:59to go down here

7:00to the border options and I'm just going to

7:02select the white option and you'll see that

7:05that now sits

7:05a lot better and I might just change this

7:08transparency ever so slightly more just so

7:11that it's a little bit lighter on the eyes.

7:14Okay so we've done some basic formatting

7:16here now

7:17and we're pretty much ready to start doing

7:19our analysis and what is key here is sort

7:22of

7:22highlighting the challenge that we have so

7:24let's let's take another look at that in

7:26more detail.

7:26Now typically when you get to this view the

7:29first thing you do is you'd probably just

7:31take the price

7:32and place that on color so let's just do

7:35that very quickly and see what what issues

7:37we have. Well if

7:38I just put the price then obviously the

7:41area with the most properties is going to

7:43have the sort of

7:44largest price so we need to look at the

7:47average price okay so we need to go in here

7:49to this

7:50aggregation which is green here which says

7:52sum and we need to change that to an

7:55average and now

7:56that we've done that we're now looking at

7:59the averages and you can start to see where

8:01we have

8:02a little bit of an issue here because

8:04obviously in a place like London or even

8:06New York any city

8:07in the world there are going to be areas

8:09which have an average price higher than the

8:12rest of the

8:13areas and the point with this sort of

8:15analysis is that actually you know when we

8:18when we just think

8:19about this a second it's no use just

8:21basically always having the context driven

8:25by some of these

8:25more expensive areas you can see here that

8:28my legend here is sort of got a very very

8:31big range

8:32here and it's it's very difficult actually

8:34to make any sort of sense of this what

8:35would be more

8:36powerful would be if I was maybe able to

8:39select a region and then see how that price

8:42or the average

8:42price in that region compares to the

8:45average price in other regions okay so that

8:48would be a much

8:49better form of analysis but in order to do

8:51that we're going to have to build up a set

8:54of calculations

8:54that do a couple of things the first thing

8:57it needs to be able to do is to understand

8:59the

9:00selection we've made the second thing we

9:02need to do is to be able to calculate the

9:04average price

9:05not just for that selection but for

9:07everything else that we haven't selected

9:10and the last thing

9:10we need to do is obviously calculate the

9:13difference between those two things so in

9:15order to do that of

9:16course we do that in tableau using a

9:18calculation so let's go ahead and create

9:20these calculations now

9:21I'm first going to remove the price of the

9:24color so that we can just have sort of a

9:27neutral

9:28set of context and when I'm working with

9:30calculations for a long while I tend to

9:32move my

9:33calculation window all the way out just by

9:35dragging this line and moving it out as you

9:37can see that I'm doing here I then right

9:39click on any white space and I just simply

9:42create

9:42calculated field if you're wondering how to

9:45get this information tab open there's this

9:47little

9:48carrot here that you can just click open

9:50and that opens up this view here and you

9:52can just see some

9:53little hints I tend to leave that open it's

9:55a shame that you can't leave it open whilst

9:57you're

9:58resizing that so that's what I'm just doing

10:00there and now we're pretty much ready to go

10:02and start

10:02creating our calculations right the first

10:06thing we need to do is simply to create a

10:08set and actually

10:09in order to do that we don't need this

10:11calculation window so let's just go and

10:13right click create and

10:15set and that's pretty much it that we've

10:17created a set very quickly and the thing

10:20about this set is

10:21we don't actually care what's in it we're

10:24going to be dynamically selecting items so

10:26initially I'm

10:27just going to use all the options available

10:29to me I'm just sort of tick this option

10:32here use all

10:32and that saves me having to make some

10:35selections then click ok and now we have

10:37our out code set

10:38the next step is to create a calculation

10:42that basically checks that set to make sure

10:46if we've

10:46made a selection or not okay so this is a

10:49very simple calculation we basically just

10:51say if

10:53the item we've selected is in the out code

10:55set that's how you sort of define that in

10:58tableau

10:58then I'd like to look at the price

11:01essentially so we're just basically isol

11:04ating the selection

11:05and the price for that selection and that's

11:08pretty much it okay we can call this

11:11selected

11:13price or we can call it whatever we want

11:14okay so I'll just call this selected price

11:21then I'm going to hit ok so we've got our

11:23first calculation okay now the next

11:27calculation we need

11:28to do is slightly more complicated and I'm

11:30going to try and explain this as I type it

11:33what we need

11:34to do is basically calculate the average

11:37price for the selection I've made okay and

11:39we need to

11:40make sure that it's taking into context the

11:43selection it sounds like a bit of a tongue

11:45twist I'm using the same word to describe

11:47the same thing but really bear with me here

11:50I'm going to use

11:50something called the level of detail

11:52calculation okay and in this particular

11:54case I'm using the

11:55exclude function in that calculation okay

11:59and the thing I need to exclude from my

12:03aggregation in

12:03this particular case is the selection you

12:06can see here an exclude computes an

12:08aggregate excluding the

12:09specified dimensions if present in the view

12:12so you see here I've got my out code

12:14present in the view

12:15and I'd like to exclude that from my

12:18aggregation and the aggregation I'm going

12:21to do is going to

12:21be the average price for the selected the

12:24average for the selected price essentially

12:27so let's go ahead and type this out bring

12:32the out code I do a colon there then I do

12:35average

12:35and we're going for the selected price here

12:38okay and that's pretty much the calculation

12:41in a nutshell

12:42so just to go over that one more time I'm

12:45asking Tableau to do a calculation here

12:47where it calculates

12:48the average of the selected price the

12:51previous calculation we created excluding

12:54this out code

12:55in the analysis so what that will do is it

12:57will give me an average for everything in

12:59the

13:00visualization so we can basically pretty

13:02much compare that okay so let's just give

13:04this a name

13:09okay so we've got a calculation available

13:12to us here and then I'm going to click

13:13apply

13:14and now we can see that available to us

13:16just here now the last calculation is a

13:20little bit simpler

13:21we just basically need to do some math to

13:24get the average price this is just type avg

13:27type in price

13:28minus and this is a key one minus the

13:33average

13:37of the average price for selection if that

13:42makes sense okay and you're probably

13:45wondering why why

13:46on earth am I doing an average of an

13:48average well it's just because of basically

13:51the way this

13:52calculation works if we just remind

13:54ourselves what's inside of this calculation

13:56if I click

13:57inside of it you'll see here what it's

13:59doing is it's basically taking it's

14:01basically excluding

14:03this out code from the analysis okay and

14:05this average price isn't doing that so by

14:09doing that

14:09we create these two contrasting values one

14:11which only takes into account the selection

14:14that I've

14:14made mind you there's multiple sort of

14:16properties and cells in that particular

14:18sort of region that

14:20I select and then on this one on the one on

14:23the left it's not excluding the out code

14:25from the

14:26analysis so it's actually calculating the

14:28average price for each out code so you can

14:31add a comment

14:31here just to sort of make it easy to see so

14:37average price computes the average for each

14:44out code and the second one the average of

14:49the average price for selection

14:58computes just the average for the selection

15:03I've made okay so that's how you do

15:06comments in table

15:06it's very useful to add that in and I'll

15:08leave that into the calculation apologies

15:10for any typos

15:12while I record this I'm notoriously bad at

15:14spelling and so we just need to give this a

15:16name

15:17and this is essentially the difference from

15:20the average okay so I'm just going to call

15:22this

15:23difference from the average okay and then

15:27now that calculation is valid I can hit

15:31apply

15:31and now we have our calculation here on the

15:35left hand side we finish the bulk of

15:38calculations

15:39and now we can start adding this context

15:41onto the chart okay the next step is to

15:45bring a few

15:45more items into the visualization so the

15:47first thing we're going to do is to bring

15:50the difference

15:50from the average onto color and you'll see

15:53that that immediately colors some of the

15:55items okay

15:56you can see that it's an aggregate

15:58calculation and then the next thing to do

16:01is to bring the average

16:02price for the selection just onto the

16:04detail what this does is it brings it into

16:07context should we

16:08need to use it a little bit later on

16:10because we need to be sort of aware of what

16:12's going on when

16:14these these calculations are being done and

16:17so we want to be able to add a nice label

16:19at the top to

16:20share the values that are being used in the

16:23calculation now if I just hover over some

16:25of

16:26these you can actually see the calculation

16:28starting to work the average price for the

16:31selection is currently 723 292 and this is

16:35actually the total for the entire data set

16:38whereas for this property e11 the

16:41difference from the average is through 232

16:45701 so the thing that

16:47might make sense here to add might be just

16:50the average price so let's add that in so

16:53we know that

16:54value in each of these data sets so let's

16:57just make that an average we'll put that on

17:01the

17:01tooltip rather than on detail I'll just

17:03click on that small icon select tooltip and

17:05now you'll see

17:06here that I can actually see those values

17:10playing out the average price is 490 591

17:14and you can see

17:15it's a difference of 232 000 from the 723

17:19average across the entire data set so this

17:23is actually

17:23starting to do the job that we wanted it to

17:26do and now what it's not doing at the

17:28moment is when I

17:29select something you can see the values

17:31aren't just changing yet and that's because

17:32that's the

17:33kind of change that we apply on the data

17:36set when it's in a dashboard these are

17:39essentially actions

17:40that are applied hence the term set actions

17:42and set controls those are typically

17:44applied at the

17:45dashboard level now the last thing I want

17:47to do is probably give some date parameters

17:49to this so I'm

17:50going to drag date onto the filters okay

17:52and I'm going to use a range of dates and

17:55just click next

17:56I can sort of choose a bunch of different

17:59ways of doing this I'll click I'll click

18:01okay because what

18:03I'll do is I'll I tend to I tend to prefer

18:05to show these in a slightly different

18:07format so if I click

18:09on this drop down then I get this sort of

18:11nice period analysis right so I can

18:13actually say browse

18:14periods and that will change this sort of

18:18filter and if you choose over the last day

18:21well there's

18:22no sale in this data set that's happened in

18:25the last day or probably week or month but

18:27if I go

18:27back a year or maybe even five years then

18:30that really does bring into context

18:32everything that

18:33we need okay you can obviously change that

18:35again and maybe choose like a starting

18:38point and an end

18:39point or even just you know looking at

18:41these items I think the issue with the

18:44browse periods is I can

18:46actually probably edit it ever so slightly

18:49to anchor relative to the largest date

18:52rather than

18:53today I can actually anchor this relative

18:57to a specific period of time so I don't

19:00know when the

19:01last house sale was in this data set if I

19:05just look at this 2015 if we just go back

19:09maybe to

19:10let's just go back to 2018 I think that

19:13should cover us off pretty well then it can

19:16we can just

19:16restrict the data set that way so just go

19:19back to you know use that and then that

19:22should be just

19:22about fine yeah that's about right okay

19:25cool so now that we've got this the next

19:28bit of analysis

19:29we need to do is to make this a dashboard

19:32and essentially make it easy to be able to

19:35change this

19:37around so I'm going to create a new

19:38dashboard just by doing that then I'm just

19:41going to bring

19:41this sheet in and immediately it brings in

19:44all the controls that we're used to I'm

19:46also just going to

19:47zoom in if I remove this little pin here

19:50what it does is it makes the map fit the

19:53space that it's

19:54actually available to fit in okay the next

19:56thing I'm going to do is I'm just going to

19:58change this

19:59title a little bit I'll just call this

20:01difference okay you could use the

20:05percentage difference but

20:07I'm just going to use the term difference

20:09in this particular case and I'm also going

20:12to add a couple

20:13of things so I'm going to add the average

20:18price in the selected region okay and this

20:23value is going

20:25to come from this particular sheet okay so

20:28if you click insert and then go down to the

20:32average price

20:32selection it actually gets the value and

20:34inserts that into the very top and I'll

20:36just drop it down

20:37two sizes so it's clear that this is a

20:41meaningful sort of different subtitle so

20:43you can see there

20:44now that this is working and this is

20:46working really really nicely

20:52now the other thing I need to do is to

20:54actually put my set into the filters and

20:58the reason that is

20:59is because I'm going to be using some

21:01interactivity in this particular

21:04visualization and notice when I

21:06drag this in it doesn't actually it doesn't

21:09actually sort of present in the same way

21:12that

21:12I want it to present I wanted to show what

21:14's in and out of the set so what I'm

21:16actually going to

21:17do I'm going to leave this out and then we

21:18're going to come back to this when it's

21:20been built

21:20so we can you can see sort of the finished

21:23result and why the filters behave the way

21:26they do

21:26now the last thing to do is to add some

21:30actions if I go over here to actions then

21:34add an action

21:35and here you'll see a bunch of options the

21:38thing we're most interested in is to change

21:40the set of

21:41values okay and so what we're trying to do

21:44is to change set values that's what I'll

21:48name that

21:50and we want to do it on a selection so that

21:51's absolutely correct and the set we're

21:54trying to

21:55influence is this out code set okay and so

21:58when I make a selection it's going to

22:00change the values

22:01of this set it's currently got everything

22:04selected so the moment everything's in the

22:06set but when I

22:07make a selection one thing will be in the

22:09set or two things will be in the set and

22:10that will become

22:12it's our comparison okay so I'm just going

22:15to click okay and I click okay again and

22:18now

22:19as I make a selection you can actually sort

22:21of see that this axis up here is changing

22:26and you notice that the color range is

22:28changing you can just see it very subtly in

22:31the background

22:32but we we kind of have a problem here

22:33because because it's fading out the items

22:36we can't

22:37actually see the visualization so we need

22:39to do one more thing and this is a bit of a

22:41hack okay

22:42we go into the sheet and we just create a

22:45new calculated field and we're just going

22:48to call

22:48this highlight okay in fact this is already

22:51in the data set because I was creating this

22:56earlier on

22:56and it's baked into the data set into the c

22:58sv so I don't actually need to do anything

23:01here I can

23:01just bring this in but let's just assume

23:03that you didn't have that available to you

23:06you just

23:07basically need to type a calculation in it

23:09can be absolutely anything it can be you

23:11know elephant

23:12whatever you just need to create a

23:14calculation and just put some text inside

23:17of it sometimes I

23:19use the term all and that will do exactly

23:21the same thing so I'll do that I'll use

23:24this new one that

23:24I've created so you can just see the

23:26process okay and I'm going to put that in

23:28front of my item and

23:30then the last thing I want to do is

23:31obviously hide these headers so that you

23:33can't see that

23:34then when I go back to my dashboard and I

23:37go to dashboard actions I want to add

23:41something called

23:42a highlight action and if you just see here

23:44the second option here is a highlight

23:46action

23:46so when I click on that you'll see that I

23:49get this interface and basically what it's

23:51going to do is

23:52it's going to apply this highlight to

23:55itself so it has this effect of basically

23:58selecting itself

23:59whenever I make a selection okay and that

24:02was actually going to come first you can

24:04see there

24:04that it goes to the top I'm going to click

24:06okay and go back out and now watch what

24:09happens when

24:09I make a selection I actually maintain the

24:12context of the visualization it doesn't

24:15fade it out into

24:16the background so that's a nice little hack

24:18that you can use to sort of maintain

24:20selections if

24:21you're trying to sort of analyze some

24:23information and now you can see that as I'm

24:25clicking around

24:26it's calculating the difference from the

24:28average and you can see that as I hover

24:30around you can

24:31even see the average price for the selected

24:34region that I'm in okay okay so now that we

24:39've built

24:39this out you can see that we now need to

24:41get onto the new feature which is the set

24:43control this

24:44selection is working but the whole point of

24:46this feature is that I can actually choose

24:48these just

24:49by using a drop down filter which is

24:51similar to sort of this sort of interface

24:54up here so let's

24:55go ahead and just figure out how to do that

24:57if we go into the sheet what I need to do

24:59is bring this

25:00out code set into the filter pane okay then

25:03I need to change that into a show in and

25:06out of set

25:07sort of option okay and I'm just going to

25:09again use all and click okay and then go

25:12back to the

25:12dashboard and then when I go back to the

25:14dashboard you'll see now that I have this

25:16option to show the

25:17set control and when I click on that I now

25:21get the full list of items that are

25:23actually available in

25:25the set and you can actually see that

25:27everything is ticked so right now it's

25:29comparing everything

25:31against the average of everything and when

25:33I make a selection here in this case e17

25:36you can see that

25:37that selection changes to e17 if I do the

25:39same again for e11 you can see it changes

25:42there and so

25:43on and so forth so you get the idea this

25:45control is doing exactly the same as my

25:47selection so let's

25:48have a go at doing that let's deselect

25:51select e2 there you go select e3 there you

25:54go and the great

25:55thing is is this has uh sort of the

25:57capabilities of a normal filter I can

25:59actually even do a single

26:01value drop down which would make the most

26:03sense here because you never want to really

26:04look at

26:05multiple items at the same time in this

26:07analysis you can just go down here and

26:09choose different

26:10items and you can see the chart is updating

26:12a little bit more okay and so that's pretty

26:15much

26:15the feature in a nutshell okay we've pretty

26:17much built everything we need to build out

26:19the only

26:20thing we've got left are some flourishes to

26:22make this a lot clearer to see you can see

26:24here that

26:24the color range is a little bit sort of

26:26extraordinary because it's sort of all

26:28skewed

26:29towards one end so I'd like to make this so

26:31that the legend is a little bit more

26:33balanced so we can

26:34just go ahead here and edit the colors and

26:37we can actually change this a little bit so

26:39we can set it

26:40to be you know go from minus 500,000 and

26:44end at plus 500,000 so anything over 500,

26:49000 which is

26:50pretty much I you know more than I could

26:53ever afford that will automatically sort of

26:57go to

26:57that end so now you have a much much more

26:59balanced scale and you can see that that

27:01immediately

27:01improves the way this chart works and now

27:04as we start to use some of these items here

27:07it's much

27:07much much easier to see okay now the other

27:10thing to make sure is to make sure that you

27:13know the

27:14legend is the right way around like when I

27:16select this option here you can see here

27:18that the

27:18difference does correctly reflect the

27:21direction sometimes you can end up with a

27:23legend that

27:24incorrectly sort of reflects what's what's

27:26going on in terms of the range just make

27:29sure your colors

27:30line up where red is not so good and blue

27:32is a little bit better we're not using a

27:35red and green

27:36because of being sort of colorblind aware

27:39for those who have visual impairments now

27:42the other

27:43thing we did in the initial example I

27:45showed you is we added a label for the

27:46selection so

27:47that's actually done inside of the chart so

27:50if I go over here you can see that I have

27:52this label

27:53option but what I need to do is essentially

27:56bring the out code itself onto the label

27:59okay and when

28:00I do that you'll see it labels every single

28:02one and that's not what I want to achieve

28:04so what I

28:05do instead is I go back into label and then

28:08I have some options here of how to apply

28:11those labels so

28:12I'm only going to choose those that are

28:14selected okay and then now what that does

28:16is when I make

28:17a selection that label shows up and then

28:20when I deselect it disappears if I select

28:22multiple items

28:23they all show up too so it's much much

28:26easier to see what's going on so now let's

28:28go back to the

28:29dashboard and when we click on an item we

28:31can see that that's the case and now that's

28:34working

28:34exactly as we expected and it's much much

28:37much nicer way to sort of play around with

28:39this data

28:40and work and so that's pretty much it we've

28:42rebuilt the chart that we started out with

28:44and it's much much easier to see sort of

28:47what's going on if you've enjoyed this

28:50video thanks for

28:50watching hit the like button hit subscribe

28:54and I'll catch you in the next video.