Make Gender Field with airSlate SignNow

Make gender field

good afternoon and evening everybody welcome to watch me vis for makeover monday week 44. this week is another viv viz 5 initiative sorry about that and it's looking at the digital gender gap so we're going to be looking at the difference between internet access between when men and women and also mobile phone access so um yeah let's go ahead and get started and if you have any questions along the way feel free to post them in the chat there is a slight delay of a few seconds so i might not see them right away but i'll get to them as soon as i can and make sure you also subscribe to the channel so you can see the latest videos uh there is a makeover monday vis review coming up on wednesday run by eva and charlie and of course there's weekly tips and last week i think i posted a couple extra tips as well so yeah so subscribe share it with other people you think might be interested and maybe next week bring somebody else along to this it's fun for me to interact with other people while we while we do this so the yeah so the dataset we're looking at this week is the digital gender gap the first thing i'm going to do is just look at the visualization and maybe give it a quick critique so um i guess the the top table there so what what does the gender gap in internet access look like um i probably wouldn't use look like because we're not actually looking at anything um i would probably use uh just something like the gender gap in internet access um and percent difference okay so it looks like it's just a really really long table uh and sorted alphabetically now sorting it alphabetically is fine if you want to be able to just look up a country because it's easier to find a country alphabetically uh and it looks like it's just a simple diverging bar chart yeah nothing particularly wrong with that and then it has the uh the value as well okay it looks like there's kind of lots of wasted space it's super wide things like that okay and then down in the map um yeah so this is where it can be really tempting to create a map because you have a country field if you look at europe for example it's impossible to read the countries are much smaller the data gets distorted by the size of the country so it's very hard to compare let's say luxembourg to brazil so yeah i would definitely avoid filled maps for the world they're very very hard to read and interpret so i know some of you will probably ask me to create a map while we're doing this but i'm not going to because they're not effective enough now this map in particular it looks like it's got color coded by something um it looks like blue and orange which i assume are going to mean the same as blue and orange above but i don't know what means what because we have for example in the table at the top we see argentina is a minus six in blue and australia is a positive two percent in orange but i don't know which one of those is male which one of those is female because there's that information isn't anywhere now i'm assuming that the map goes by those same that same color palette and then it has a shading on it that uh looks like most things are gray because they're close to the center now the the issue i have with this is if you look at for example um let's say uh what let me look at for for a minus two here i'm sorry if i don't know the country here that's really terrible of me but there's a minus two percent kind of rate below russia there and that minus two percent is pretty blue whereas the two percent in australia is rather gray meaning it's kind of in the middle so um it looks like they've chosen to use the full extent of the color palette which makes this look a bit misleading as well okay so let me close that and go back over to the data set and let's look at the article that was posted okay so what are we looking at here so this is the inclusive internet index 2020. uh the overall index score based on the okay availability is green affordability is this kind of red okay so it's looking at a series of rankings oh this is pretty cool uh so if i select that what happens overall rank breakdown okay overall rank okay so this is kind of showing us each of these what happens when i click on these dots okay nothing sort by name okay so this allows you to sort by name sort by ranking okay it looks like the dotted line connects up the ranking here now we also don't know what these values are because when we hover over them it just says like sweden is first overall but new zealand etc but that's not particularly useful because i have to go to each of these individually to see yeah i mean the the the animation's pretty cool but i think that's probably about it all right so let's get stuck in here the data set if i scroll down a bit is uh let's see so we've got country number of internet number of households with internet the gap in internet the gender gap and internet access the gender gap and mobile access okay so this is impossible to read because we don't know what the difference is it doesn't say female versus male or anything like that so huh okay source article provided by opera okay so there should be us according to that there should be okay so let's okay here we go so maybe this tells us then so this source article i just need to understand when it says gender gap does that mean you know is it is it comparing females to males or males to females so hopefully this loads up at some point oh and i made cookies last night uh and eva said that they're the best ones i've ever made chocolate chip they're quite delicious i actually have a plate full sitting here next to me and i might just have to eat them all while i wait for this this pdf to to turn up okay let me see if i can just download it instead maybe that'll be quicker okay so let me close that okay digital gender gap blah blah blah okay um okay about the data the data explores the gender capitals using both calculations positive values indicate that so right here positive data indicates that male access exceeds female axis while negative values indicate that female indicate that female axis is greater okay so if i go back to the image so in argentina female axis is greater than male axis this is really confusing let's see here in addition the data explores a percentage of households with internet's defined as by a computer okay so a negative number means female is greater okay and then argent okay so we're just gonna have to take that at its word okay so i've gone ahead and connected to the data here i'm gonna go to the metadata view because i'm just going to go ahead and rename the fields here i would normally just click on the little triangle and rename it here but i don't i don't have any idea what the name is so i just switched to this metadata view so country is fine internet users percent so this is if i go back here percentage of households with internet access at home okay so this is percent of households with internet access and this is [Music] gender gap internet access and then this one would be gender gap mobile phone access okay very good and i'm not sure actually let me go back to edit my data source i'm going to join this to another data source so i've actually posted this data source on data.world and i will um in the notes for this vis after after it's published and everything i'll go ahead and include a link to this data set but it includes the country the country 2 and 3 digit iso codes um the numbers uh what region and sub-region it belongs to it's could it can be a really useful data set um so i'm going to go ahead and and join to that data set so let me add uh let's see more and i want to go to i think it's here yep and i'm going to just drag it oh which one is which here so let's go it looks like there's two sheets here oh here we go info and then g oh okay so it looks like this actually also has latitudes and longitudes oh good thing i didn't know that but i all i need to do is connect to the info and i want to set up this relationship come on i want to go country to country performance options uh many to many so i'm going to go one to one that's basically just like a join okay and then if i go back here or actually if i go to my sheet i should now see all these other codes now uh i'm going to keep those the country code number i don't need the second country i don't need this i don't need these two i don't need i'm just going through and getting rid of the fields that uh that are unnecessary right now okay so region code i don't need so hide so i'm going to go ahead and just bring the region and country into the view and why do i have null here okay and i actually i don't want to do that i just want to bring i want to verify that i this uh this table here so this is gender gap in internet access okay so if i put that here we see australia is at two percent it's two percent and argentina is at minus six percent okay so uh good okay we can verify that so what i'm going to do i know i need to compare uh or you know this is simply you know i could just kind of sort this and maybe see which ones uh are above or below this tells me that for example these are all zero so these here it looks like so how many is that that's uh 15 out of 100 so 15 percent of uh the countries in this data set uh women have more internet access than men uh that's internet access let's see what it is for mobile phone and let's sort that and for mobile phones it is let's see what we have here it's 17 okay so slightly more for internet access versus mobile phone okay so i want to compare these two metrics so i'm going to actually just drag them on top of each other and we see we get a side-by-side bars and i'm going to also copy measure names onto the color shelf okay so now we can see both of them together um let's see i'm going to go ahead and flip the chart because i think it would be a bit easier for me to look at not really okay so that's not very useful um so let me duplicate that sheet i'm gonna flip it back the other way and i'm gonna take measure names and just move it to detail okay so i could now so look at what i'm looking at now they're stacked on top of each other so i want to go to analysis stack marks and turn them off and if you were here last week for the one where i did time you're going to see a lot of these similar kind of charts okay let's see and but now we need to put that on we need to put measure names on size as well so now this allows us to compare internet access versus mobile phone access and we could see kind of the difference between the two okay we could see some of them go so for example in the philippines 14 more women than men have internet access but for mobile phones it's the opposite or men have more access than women okay so that's one view let me duplicate that um i've got to go ahead and take yeah let's just take that off color for now i'm going to duplicate my measure values field but on this one i'm going to make it a line and i'm going to connect it by measure names now i get these little lines in between i'm going to go to my first one and make it a circle and now if i make this a dual access chart and then i'm going to synchronize and let me go ahead and move the line to the back you'll see that i get like a little barbell chart and i could maybe color code that barbell by whether you know which one's higher so if i wanted to do that i could say something like um let's say internet more internet access than mobile phone access i know it's a long name but and i'm just going to say the sum of the internet access is greater than the sum of the mobile phone access and i'm going to go to my line and it's a boolean you'll see it's a true false so you'll see it's a little bully in there and i'm going to drag that field onto my color shelf and i get a single color that tells me true or false so what i could do here is if the blue is bigger so i'm going to switch these colors around i'm going to make the true blue and the orange and the false orange and now this tells me um depending on the color of the bar it tells me which one's higher so for example if i click on mobile phone access you can see iran has higher mobile phone access for women than it does uh internet access okay so that's one way you could maybe look at it so this is our barbell um another thing we could do though is maybe we want to sort that so i'm going to just duplicate that boolean field i created and i'm just going to call this a difference in internet let's see i'll call it internet versus mobile phone access and i'm just going to do internet minus the sum of mobile phone so same two fields but now that i have that i can sort my countries uh let's see i want to do descending by the difference mobile internet versus mobile phone and there we go so the wider the bar the um the bigger the difference between internet access and mobile phone access and they're sorted that way so at the bottom you're going to see the orange bars okay so let's duplicate that and i'm just going to turn this into like a piece in the pod chart i think i did this one last week as well it's the same thing as barbell i'm just going to make the the lines a bit bigger so they surround the circles maybe not quite that big you get the idea here and then what i need to do is i need to go to the circle shelf and just put a border on there um not particularly great what i might do for this example is maybe on my color for my line i could maybe reduce the opacity so i could see kind of a light blue and then a light orange so that's another way to do it um so this is our piece in a pod i don't know what kind of chart to call this but they kind of look like peas in a pod to me um okay what else could we do we could do maybe if i go back to this one and duplicate it again i'm going to create a slope graph and make this a slope graph what i want to do is well first off i'm going to flip it and i'm going to change it to a line take me and move measure names to the path shelf let's see and then i want country on detail let's see what did i mess up here measure names here yeah there we go so if i make it a bit wider um yeah and now i could take that true false maybe put that on color and i could see which ones have uh higher mobile phone access than internet access or vice versa so what i could do is uh i'm not going to worry about that yet okay so in total we have how many oranges are there let me just do keep only i'm just trying to count up those so that would be 56 marks so this should be 28 countries yep so 28 countries have more i'm just going to make a note here maybe i'll show my caption so 28 countries in 28 countries women have more mobile phone access than internet access and then so that would be so 100 minus 28 in 72 countries it's the opposite actually let me just write it women have more internet access than mobile phone access i don't even know if i'm saying that right do women have more mobile phone access compared this compared to men uh women yeah so this actually isn't this is really a terribly worded analysis here because this is this is showing yeah i'm not wording this right because what each of these metrics tells me is the difference between the men and the women so um it's really women have more mobile mobile phone access compared to men then internet access and then it's the other way around so compared to men there we go okay that makes more sense now it's a subtlety but it's an important one um and i just like putting that in my caption just so i can see kind of what uh what my notes here um okay and it's time for a cookie break um what else could we do here um one second michael yeah i'm on the i'm on the live stream you're being quite loud i'm on the computer sorry just my son having cereal at five o'clock um so i'm going to go back to my chart chooser here and i want to see if there's any charts that i could be missing here and i'll post links to this as well so i want to compare categories so bar grouped bar diverging bar we did these deviation floating bar this is kind of like our piece in the pod i think i did this one last week as well i could um duplicate this barbell and instead of these being circles i can make them gantt bars and then instead of this being measured let's see we want that to be measure names [Music] no we don't actually want the second measure names we want this to be the difference mobile phone so we need to make that continuous and if i put that on size uh i need to just show one of these so internet there we go let's see if that's right so here we've got 13 percent and 61 percent and 61 and then 30. okay yeah so this shows the difference now and i could put that on color and then if i scroll down you'll see the bars get wider as we go down so same thing as the barbell just uh done as a gantt bar as well so they're calling that a what they call that here floating bar chart and that's not too bad but what mean you know you could always just filter it by region maybe and let's say we want to look at maybe africa and you can see kind of the differences there so it's another way to kind of look at the data okay panel some of these don't apply x y okay we did the dumbbell bullet graph we don't want to do i mean if we were going to do a bullet graph you'd let's see what would that do so i'm going to let me duplicate this sheet and what i would do if i'm going to do a bullet graph is i would take the internet access and then move the gender gap to the the detail shelf and do an average line for each cell okay i think i did that wrong okay and then i need to edit that and make it my mobile phone access and there we go so now let me uncheck that so now we have our little reference lines here let me actually edit those or format them i'm going to make them maybe all the way dark maybe a bit thicker and then i could put my little color thing on there again so maybe put that on color and now we can see see that as well we could sort these by the gap uh we want to do it by or the difference between the two and there we go so that's not particularly useful yeah i don't like that one but what do we call that one that is a it's not really a bullet graph it's um let's call it a bar graph versus reference line all right um so mohul modi so uh back over here to the slope graph um is that analysis on the slope graph correct is it it is just giving a comparison between energy um it's not comparison it's not comparing between men and women that's correct but each is comparing the difference between men and women so the the numbers that we see here like for example if i ever hover over philippines and it's a minus 14 percent that means uh 14 more women have internet access than men whereas on the other side we see that uh 12 more men i i'm sorry uh let's see so this is 12 so this would be 12 more more men have mobile phone access than women yeah i mean it's it's yeah it's not a very good analysis i would agree um but it's not it's definitely not comparing internet access to mobile phone x's that is not what this is showing um so this is a this is actually a view that is not uh is not very good okay so let me go back over here waterfall parallel coordinates all right all right let's see what else we have here uh let's see okay distribution distribution could be interesting um i wonder if we did maybe something like a dot matrix let's see uh so what that would mean is uh let's say that we want to look at the percent of uh so let's say we want that to be in the columns and then we want the actually we want this to be let's create a let's create bins on this and let's say we want to go every so that's every half percent so let's do every that's every five percent let's do it yeah let's just start with every five percent put that on to the rows and if i put country on the rows or sorry no country on detail i'll get a dot for each one of these so that's not uh yeah that's not particularly useful why am i getting let's see i need to show the highlighter and if i highlight australia so i'm seeing australia and every one of these that's not right i shouldn't see australia in every bin um each country should only be showing up one time that's i don't get that okay let me try it this way then let me do um oh no i think that was right but this needs to be this needs to be a no this needs to be a count distinct country there we go so this is telling me how many countries have so the ones on the left-hand side this means more women have more mobile phone access than and over here is the other side and then the zeros are between zero and five so some of them might be zero some of them might be five percent it's kind of hard to uh um so both both metrics can be positive that's correct all right [Music] okay so that's uh so this is i'm just gonna call this internet internet access bins i'm going to do the same thing but i'm going to do it with uh mobile phone access let's see create bins and let's do 0.5 again and this time i'm going to put that up here instead and we can see kind of a shift here between the two [Music] so okay it still doesn't tell me a whole lot all right um let's see so that's our histogram um could we do a box plot possibly let's see what a fox plot looks like so if i do something like internet access and put country on to detail make this a circle and i'm going to make it a bit bigger so we can see it a bit better and reduce the size of my circles okay and then if i put a box plot on uh you'll see we've got a few outliers here uh so that's and i could then maybe put the where is it here uh mobile phone access here now we can see the distribution again so let's do analytics box plot for each cell okay there we go so we've we've got only one outlier for internet access that's ethiopia so 30 more women have mobile phone access than men uh i'm sorry too we've got pakistan as well uh so pakistan's an outlier for both so women have much more no this is men sorry men is the positive number so in pakistan significantly more men have internet access and mobile phone access than women well that's that's not good um india bangladesh okay right okay um i could maybe take this okay i think what i'm gonna do this is maybe think about maybe just a rank chart so let me if i take my slope graph and what i'm going to do is i'm going to change each of these to a rank so rank and then we want to rank those by country and then quick table calc rank rank by country let me get rid of the color okay so now we need to flip this around uh and what this is going to tell me is actually i'm going to leave it like so a negative number so so the numbers that are at the top that would mean women have more internet access than men so let me show the highlighter so if i take for example let's see we still don't know actually what the value is but if i okay austria yeah so this is another one that's kind of hard to tell what it's doing um what i'm trying to show is where does this rank amongst other countries um but i would need to put the measure values on to detail as well so if i look at why isn't it on my tooltip oh okay oh i see yeah i need to put them on from here okay so the philippines is ranked the highest in its or the uh yeah this is another one i can kind of understand it but it's very hard to read so um this would be our ranked slope graph you know my general kind of rule of thumb is if i create a graph and it's very hard for me to explain what the graph is saying then i probably won't use it because it's going to be too hard for the audience to understand so i can kind of get this in my head but it's too it's way too difficult for me to explain to other people um okay what else can we look at here let me go back uh rich plot okay so i think that's probably it from this site she has distribution i mean we can always do big numbers um yeah that's exact values so let's look at another option here chart chooser okay come on okay fin chart target lines we did that calendars by the way i did a video uh last week on how to make these tile grid maps um deviations we did actually mine was a tiled grid map but with a line inside of it as well heat map waffle bar line okay i'm just looking at okay so we didn't do a scatter plot so let's see what a scatter plot does so scatter plot i want to look at internet access versus mobile phone access access country on detail and okay so maybe we're on to something here okay so we've now have kind of a quadrant chart so okay i think what i'm going to do now is i'm going to so if i put on reference lines let's see if i do an average line for the table what i want to do is i want to write a calculation that's going to give me these four colors here so oh i need to turn off those recalculate i hate those so edit turn off the recalculate and then let's edit this one and turn off to recalculate come on okay so what we want to do is we want to maybe like color code this quadrant versus this quadrant so we want to create kind of like four four sections i'm going to show you maybe two ways to do that um so i should get 27 up here so i'm going to create a calculated field and i want to do i'm just going to call this uh i'm just going to call this quadrant and i'm going to say if the the sum of the mobile phone axis is greater than the window average of the sum of the mobile phone axis so this window average this field right here is equivalent to my uh my my reference line here the 0.0630 um let me see if i can do this make it a bit bigger for you so we can read it a bit better and the sum of gender gap or internet access sorry is greater than the window average some of the internet access wow shoot then i'm going to call i'm just going to call it uh what do i want to call this i'm going to call it you are for upper right for now i'll come up with a catchier name later and then i want to copy that else if oh god i hate when tablet does that like why does it want to hit paste why does it put in a new data source god that drives me insane so now if this one is to the right and this one is to the left then this is going to be so let me do it like this so i can read it a bit better oh and i lost my else if here okay so this is saying so if it's to the right and it's below so then this would be my uh lower right i probably should make so write this out upper right i'm just going to copy that and then i want to do if they're both less than then that's going to be my lower left else we're going to be upper left and then end okay so let's put that on to the color shelf and we want to compute this using country and we get four countries our four countries four quadrants so uh yeah so what i'm going to do is i'm going to edit this and i'm going to put my value on my computation maybe make it a dashed line okay and hit ok and that puts my value at the bottom change the color and then same thing with this one so let's edit that put the value like that make it black okay but this one is kind of hard for me to see this 13 here so i'm going to format that and i'm going to align it to the right and then set it to a percentage so 12.9 percent and that same thing here so i'm going to put this one this label at the top so let's go top numbers percentage one decimal okay so now we can see which kind of quadrant they're in and we could count the um so you know we could even we don't have to count them but we could just uh yes and now we know which ones are above and which ones are below okay so that gets us that view so this is our quadrant with table calc and i'm going to duplicate that and we're going to write them as level detail expressions now so the problem now is on my table calcs i can't right click on these fields i don't see any edit alias options so if i want to change the names of these i have to go into the calculation so i would have to say if it's on the upper right instead of upper right i could say [Music] actually we probably yeah i actually don't even want to do it this way i want to have them at zero so if that is bigger than okay so forget it we're not going to do it as and that is greater than zero because we actually want to refer to zero not the average so i've got that wrong okay and i'm going to make these i'm going to disaggregate these because there's only one number for each for each country so and i want to say this is bigger than zero oh crap let me see all right i'm gonna write like this might be a bit easier to understand um hopefully it makes sense what i just said because we don't uh i'm going to change these reference reference lines to say zero instead of um instead of comparing them to the average the average doesn't make sense here zero i'm just cleaning my calculation up to make it a bit easier to read okay so get rid of my bracket there hit okay it's going to break that but that's fine oh something else is broken here oh another this should be all right that's right i just need to get rid of the bracket there we go and then this is now a dimension so i need to put that on the view okay and then these should both actually be this needs to be a i need to edit this and i want to make it a constant instead and the constant should be at zero and i'm now going to say no label because what we're actually comparing here is the men to the women not to the average so okay there we go and then my colors are something's not right here [Music] all right let me double check my calculation here so okay so nope wrong one where's my quadrant so that's greater than or greater than would be my upper right so let me just click on that that looks good and then lower right would be all the oranges and then lower left that's probably because some of these probably need to be equals too let me just make all these equals too [Music] um what the hell okay i think that fixed it no we still have one down here so let me make all these okay there we go now we're good so lower right is going to be that upper left right okay but now there's the dimension i could just edit the aliases here so instead of going into the calculation i can choose aliases and i could uh edit the names here so this is telling us so these the ones that are green are the ones where men so out of these so 74 countries out of the 74 out of the 100 countries actually i'm going to double check and make sure that i'm capturing all because i did the um i did the relationship in tableau instead of just a regular join so i'm going to just double check and make sure there's 100 countries in here yep okay very good and i can close this one as well close that one okay so now this is telling me uh right and then i'm going to format both of these default properties number format percentage to one decimal and i need to figure out because i don't like how those are negative signs so i think yeah let me just leave it like that for now and i'm going to form i think i'm going to stick with this scatter plot for my uh for my final biz here so percentage zero decimals the problem is the pain so percentage to one decimal yeah so you see this is this is where it's really stinky because like i have my i want to be able to format the tooltip with one decimal put the axis with zero decimals so it's a real pain so i have to like duplicate these fields which is like really stupid and then put those onto the tooltip and then these two fields my copies i could default properties number format and make those one decimal and now you can see that one in the tooltip so format here so let's see wrong one let's format that as a percentage so now my axes look right and when i hover over dot you'll see some of them are one decimal and some of them are two because i made the copies to be one decimal so what i would do here then is i would uncheck include in tooltip on these and i'm going to uncheck quadrant including tooltip as well because that tells me this now tells me the country the axis access i keep saying axis so actually let me just say cancel for now so i need to figure out a way to word this a bit better um okay so i could focus on on maybe just these numbers down here so we've got only only six countries where women have both more mobile phone access and more internet access so okay so what i'm going to do then is um i want to count those so let's see i want to say more mobile phone and internet let's see more access to mobile phones and internet and i'm just going to say if quadrant equals lower left then return the country and and then i want to count those up so i want to get just a single number that i can put in the in the the the title of the sheet so i'm going to need to make it a level a detail expression so i can aggregate those a bit farther okay so all right let's see so it looks like the stream is a bit messed up here so let me let me stop and let me start it again and hopefully it picks back up here in a second okay can you please let me know if you can still see the see the stream because what i'm going to do here is i'm going to i'm going to count these up so i'm just going to wrap them in a mustachio and i just wanted to count distinct on that now notice i didn't put a fixed or anything in here let me just do it like this might be easier to see and what this what this means is just kind of give me the grand total uh ignore all of the dimensions so it'd be something similar to doing fixed and then don't list any dimensions so um okay thank you marcin for telling me everything's okay so let's hit ok and now if i put this in my on my detail shelf and i show it in here so what is it here uh more access to that and hit apply you'll see we get six so uh i could do the same thing then for the upper right and maybe our title then has both of those so let me duplicate this and this time i'm going to say let's say less access to mobile funds and internet so i want to call this one upper right and let's put that on detail and now what i could say let me just put a i could say in only of 100 countries [Music] women had more access to both compared to men for both the internet and mobile phones in only six of 100 countries however [Music] i can now insert the i could just switch this around so let's see let's make this 12 again men had more okay i'm going to rewrite this i'm going to get rid of the italics this time however men had more access compared to women for both um countries okay so let's get rid of that and maybe make that italics and let's see what that looks like so women had more access compared to men like more access compared to men for both the internet and mobile phones and only six let's make that bold of 100 countries however men had more access compared to women across both technologies in let's make that bold as well okay i'm going to fix the colors on those i kind of like the way that's turning out um but what i'm going to do now is i'm only going to highlight those two quadrants so i'm going to i'm going to make my lower right and my lower left i'm going to make those both gray so let's just make those gray and then my up my lower left i'm going to maybe make let's maybe make that maybe red and then i'm going to pick a different color uh let's see oh maybe we should let's see um let's go with we don't want to do that um maybe let's put that kind of blue okay so i need to get this color okay okay so i think that's pretty good now i need to rearrange these so that the blue is in front of the grays okay so i think that's good and i think i'm going to try one more thing so create calculated field um i want to set the axis on both of these to be the same so what's my so let's go from uh minus 0.1 now let's say point let's see this one all right to make the access the same i'm going to do something a bit different here so let's do so this one is 70 internet access okay so i'm going to copy my internet access field here and it's going to give me all the dots there i'm going to actually take all of these fields off oops and then i'm going to make these transparent small turn off the tooltip and now you'll see they're here somewhere uh let me get rid of that line oops i didn't want to do that and now if i make this a dual axis and synchronize now my axes are the same on both sides and i'm going to hide this one so let's uh let's do this let's uncheck and now if i hide that header you'll see my axes are now the same on both sides so a little trick there for you and i want to make sure i move these to the front and yep okay so now those little dots i mean if you hover over one of them you'll see it like right there but you know i'm doing it just for aesthetics so let's format this a bit more get rid of our row and column dividers and uh let's see i want to oh my computer battery is running low um all right please use instead of however however makes it sound as if it is better but instead isn't the right word though um yeah i think you write that however isn't the right word but uh instead is not instead means it's a replacement um let's see no i do want it to be however because i want it to look like it's not fair because i don't think it's fair that men have more access to the internet than women so i'm going to leave it as a as a however let's see so i hope that makes sense why i'm saying that i just think that internet access should be the same for both so um i could say maybe meanwhile but i want it to be however because uh i don't think let's look at the definition of however and let's let's see if it clears it up for us used to introduce a statement that contrasts with or seems to contradict something that has been said previously right so that's what i want i want it to be a contradiction so um so yeah i'm going to leave it as yeah i could say yeah i think you're right denise so i could say men comma however there we go like that i think that is that what you mean denise i believe it is um okay so uh let's see so i'm gonna change this title um yeah i think that's okay but i need to somehow make it look like values that are below zero need to be um i need to somehow make it obvious that there's that whole negative thing so i could maybe all right so i'm going to stick it in the dashboard civilian and i'm going to delete the lod1 so let's stick this into dashboard and uh i'll leave it at thousand eight hundred what the heck uh floating i'm gonna stick this here get rid of my color shelf and then zero zero one thousand eight 800 and add about 20 of padding okay right so what i think i'm going to do here is i'm just going to annotate this area go away annotate area and i'm going to say women um let's see axis that meant maybe i'll try something like that make this let me see if the hell that's going to work out so if i put that kind of down here in this corner and i'm going to get rid of the shading get rid of the line okay maybe something like that i could do a smaller font maybe eight point maybe women have lexa have less access than men okay but now my scale is all messed up i don't have my axes ranges aren't the same anymore so i need to either make it taller or wider so why don't i if i make it skinnier the heck i'm just trying to get my kind of my scatterplot part pretty evenly okay all right let's see i'm going to make that a slightly smaller font uh maybe if i make this one a bigger font see it looks like it's 18. yeah i like that um right and then let's add our caption oops i meant to so dashboard this needs sorry i need to change this object back to 1000 and then you change my dashboard size to 900 by 800 there we go um so in my caption i need to now put in my data source and that's going to be what's the data source uh let's see come on come on our data source is is so let uh just copy that and i'm going to put that in here created by okay there we go all right so just at an hour and three minutes um hopefully you found that uh let's see i thought there were countries where women had more access than men in the lower left quadrant uh let's see women have oh sorry this should be women have more access than men sorry that's completely backwards yeah there we go women have more access than men [Music] thank you for that clarification [Music] um yeah okay if we wanted to allow the user to find a specific country in the distribution and we'd be able to add a filter type no oh that's a good point i should allow them to find a country so i'm going to actually just show a highlighter and of course tableau puts it as let's see so let me find that here and i'm just going to say find a country thank you that's a really good idea and then i can maybe make that smaller and i'll put that maybe i don't know maybe i'll stick it where do i want to put it here okay so why don't i on the designer here i'm going to maybe stick a border on it light gray border i'm going to add some padding so let's do 10 but now i need to make it a bit bigger and then i'm going to set the background to white okay there we go so maybe something like that thank you for that tip so i want to do the y position to that and then 20 okay that should line it up perfectly and then my height i need to reduce a couple pixels oh shoot that's not going to quite work good enough um i think that works do you like that uh okay okay so i think that's it thank you for the um the commentary the suggestions and things i think that's great so if i highlight a country now i should be able to just locate them anywhere in the view last thing i need to do is actually clean up my tool tips so let's see what do i want to have here so i have country more access than oh okay so i need to get rid of the tool tip there the tool tip there and i should just be left with two metrics so let me go into my tool tip and change this to say country maybe i'll make that like 12 point gender chap internet access gender gap mobile phone access and let's