IT4U91: 50 Tableau Tips

Coming to you live from the shadow of the big house, it’s IT4U Tips and tricks on ITS tools, products, services and more, with your host, Jeanne Mackey [MUSIC] >> I’m your host, Jeanne Mackey These are interactive webinars brought to you by information and technology services And if you’re having any audio or video problems during the live webinar, let us know in the chat pod If it’s not on our end we can offer some tips And if you’re watching the YouTube captioned recording, check out the description field for a link to a resource doc If you do need an accommodation to participate in a live episode, just give us a little bit of a heads up and we’ll make it work So today, we’ve got Christopher Gardner from ITS/Information Quest And he has promised to give us something approximating 50 tableau tricks >> Thank you Jeanne, hello everyone All right, I am going to get us started here This presentation was something that’s been done at Tableau at the Tableau conferences for several years I decided to watch a few of those videos And see if I could take some of the key tips from each of those videos and put them into a presentation for the U of M campus So I am gonna dive right in and get started, since we have a lot of tips Hopefully everybody can see my desktop, see my tab load interface >> Just put stuff in the chat pod and I’ll relay the questions to Chris >> All right, so if you have any questions or comments, please let Jeanne know and she’ll pass them onto me All right, starting off at the beginning, colored tabs, the first tip for you You can add color to all of your tabs in Tableau The easiest way to do this is to right click on the tab, go to color, and assign a color to the tab This is especially useful if you want to remember which dashboards you want to publish or not publish When you go to publish your workbooks it’ll actually show the colors from the tabs on the screen when you look at the sheets So you can see the colors right here next to each one It’ll make it very easy to identify which sheets you want to publish That is tip number one I’m not going to publish right now Tip number two, you can quickly add data to Tableau Rather than going to the data screen and trying to find your Excel file that you want to put up there You can actually browse in a window and find your Excel file, or whatever it is you want to connect to In this case, I’m going to find the helmet data, Helmet_Data.csv And I’m just gonna drag it and drop it right in Tableau When you do that, it’ll automatically take you to the data screen and it’ll automatically import the first tab in the spreadsheet So you can start working with your data right away The next tip, tip three, you can copy data from the preview pane So up in the upper left hand corner in your data there is a view data tab You click this button, you can quickly see the data in your data set You can click this upper left corner and highlight the entire data set Copy it, and paste it right into Excel or whatever software you want to paste it into It’ll do it in just a minute, once my computer catches up to me I’m going to pause this for a minute and go back to the display But you can copy everything out to Excel You can also copy data from a visualization If you have a visualization that you have created in Tableau, and you would like to see the data for it, you can copy the data Simply click somewhere in your visualization, hit Ctrl+C to copy it Cmd+C to copy it on a Mac Go into Excel, I’m gonna create a new sheet, and I’m going to paste it in And it pastes all the data from that visualization into a spreadsheet so you can quickly examine it Number five, how to quickly add a calculation? So you’ve got a lovely visualization and you want to know what happens if the profit doubles You can quickly add a calculation to any pill on your dashboard by double clicking it and adding the calculation to it Times two in this case When I do that it automatically doubles the sum of the profit So we can look at what it is if it was twice as much Continuing on that, we have our next tip We have created this lovely sum of profit times two I want to make this is field that I can use elsewhere in my workbook If you hold down the control key, click and drag the pill over You should be able to add it over here, if it will let me I’ll see if I can get it to do it here You should be able to add the field to your list of menu values And it’ll save it as an actual calculation over here on the left hand side for

use elsewhere Number seven, you’ve built a lovely dashboard, but you would like to keep these charts separated a little bit You want a line between them There is no actual line feature in Tableau, but you can create one on your own The easiest way to do it is to grab a blank, drag it in, and drop it in-between your two dashboards When you do that, you’ll want to go to the layout and set your padding to 0 all the way around Once you do that, the size of this will be whatever you set it to be In this case, I’m gonna set it to 5 pixels I can then go into the background color, set it to black And I have a nice dividing line between my two visualizations on my dashboard Tip number eight, do you have any questions while I’m working on this? We’re gonna keep going If you have any questions, please add them to the chat pod and Jeanne will ask them to me Tip number eight, you can duplicate any tab in Tableau and you can also duplicate it as a cross tab The first thing you’d want to do is if you duplicate it, this just allows you to edit a secondary version of it without screwing up the first one If you wanted to try some stuff without screwing up the first one Right click, duplicate it, and you can mess around with this one without worrying about the first one being ruined The other thing you can do is right click and duplicate as cross tab This allows you to view a cross tab version There it is, of your data, quickly and easily you can see all the data in here and verify that your numbers are correct Number nine, this visualization is using measure names and measure values I have my Profit, my Sales, my Discount, Profit Ratio, and Quantity And I have, yes, measure names up here, my measure values are all listed over here I’ve added color to the measure values And what you’ll notice is because sales has such a high value here, all the other stuff is washed out Especially percentages, cuz they’re so low They all end up just being the gray You can actually go under the menu for measure values when it’s a color and use separate legends And it will color each of your columns individually by that color, and do the gradient within that color So there’s blue for profit, purple for sales, red for discount It’s a very clever way to add multiple colors on the same visualization You don’t have to do multiple colors on just measures, you can also do it on dimensions So in this case I have my product category, which is on color, and it’s split up into product subcategories You can go under products subcategories, when it’s a detail, click on the detail icon, and switch it to a color Now it will color each of the subcategories by a shade of the color of the primary category So all my subcategories within Furniture are a shade of blue It makes for a very large legend, but it’s a way where you can quickly split things up and still keep them kinda grouped together Nested bars, so a lot of times what you wanna see is how two things compare around the same month So I wanna see how 2017 compares to 2018 for January I can kinda do that, but it’s hard to see But I also want to keep the trend between 2017 and 2018 on the same chart One of the ways to do this is to stack the bars So what we’re going to do is we’re gonna take Year, and this is actually kinda of a tip itself, but if you hold down the Ctrl key, you can click and drag and make a copy of it on to size And what you’ll notice is that it took my 2017 and it shrunk it down I’m gonna go up to my Analysis menu, under Stack Marks, and turn off the stacking so that they’re no longer stacked This makes both of my bars start at the origin and go up from there, this is called a bullet chart What this allows me to do is I can now see the trend in 2017, and I can also see the trend in 2018 But I can compare the two within each month and see how they compare, nice easy way to do that We use this very commonly when we’re working on admission data, when we’re looking at admission selectivity and yield Any questions so far? No questions so far, gonna keep moving All right, Dual Axis, right now, we’re looking at profit and sales over the past few years What if I wanted to see them on the same chart? Well, I can do this, to do this, you simply right-click on the axis and say, Dual Axis This will put sales on one side, profit on the other, and put the chart on the same visualization, but there’s a catch What you’ll notice is it looks like our profit is about the same as sales

But that’s because our profit legend, or our profit axes, has a much different scale than our sales axes So what we need to do is right click on the profit and synchronize the axes Now there is a caveat to this, if you ever have a problem where you cannot get Dual Axis or Synchronize Axis to work, what you will need to do is make sure that both of the measures are of the same format They both either have to be integer or they both have to be decimal One cannot be one and one cannot be the other, otherwise it will not work, they have to be the same format So you can do duel axis that way Next, trend lines, in this case I have all of my furniture, my office supplies, my technology plotted out here out on a visualization And I have a trend line for each one of these To add my trend line, I went to Analytics on the tab over here and added a Trend Line But let’s say I don’t want a trend line for each of the colors, I want a trend line for overall You can do that, you can right-click on the trend line, on any of them, Edit the trend lines And you can actually turn off trend line per color, and it will create one trend line for the entire data set A nice easy way to switch things up when you have multiple details on one visualization This next one is a little bit involved, but it’s a very cool trick Right now what we’re looking at is the profit ratio for a particular month and year In this case, I think we’re looking at, let’s just look at September 2017 I wanna look at this day-over-day, and I wanna see it in calendar format, and you can actually do this So, let’s take our order date, and instead of left-click dragging I’m gonna right-click drag, and I’m gonna drop it on columns In the columns, I want the day of the week, so I want, day of the week, weekday, I’m gonna say OK So now I have Sunday, Monday, Tuesday, Wednesday, across The next thing I need to do is drag order date again, right click up to Rows And I want it to be the week of the month, week, I’m gonna say OK And you’ve actually created yourself a little calendar with the profit ratio on each and every single day Now this gets a little bit more interesting because we can add additional months Now when I add an additional month it’s gonna average it over the two months for each of the days Well that’s not exactly what I want What I need to do now is add a month to my rows, and say OK And now I have September going down like this, and October down here If you wanna see the day of the month, you can drag Order Date onto the label, set it to the day of the order date And it’ll put the numerical day of the month on each of the days You’ll have to do a little bit of trickery to get some of the blank days in here, we have some blank Thursdays in here But there are ways to do that and I suggest you look online for instructions on how to do that But it’s a quick and easy way to create a calendar in Tableau Okay, we’ve made our lovely calendar, lets do a little bit of cleanup So if you hover over it, you can see the weekday, the week, the month, and everything that we have in this visualization But lets say we don’t want all that information in here We don’t need the week of the order date in there, I don’t want that showing in my tooltip I could go into the tooltip and edit it and remove it, but there’s a faster way If I go up to the week of the order date, click on the pull-down, I can actually tell it to not appear in the tooltip, and it’ll go away It’s a quick and easy way to clean up your tooltips, and keep the Tableau format if you’d like I’m gonna pause real quick, any questions while I’m moving forward? All right, going to keep going Okay, we have a lovely map here, and I’m Looking at the sum of profit for each of the the postal codes within the map But one of the things you’ll notice is that all of my big data is hard to see because it’s hidden behind some of these other points I wanna bring those points up to the front, how can I do that? Well, the easiest way to do that is create a calculation based on your profit and set it to the absolute value So I have already done this and I wanna show you this calculation It’s simply the absolute value of the profit What I’m going to do next is I’m going to sort the postal codes, By a particular field, the field that’s absolute value, absolute value of profit, and I’m gonna do it descending What that will do is it’ll take all my very, very big values and all my very, very small values and bring them to the front Now when I look at my map, I can see all the very, very big and very, very small values right up front, very cool trick This next trick was very cool, I found this accidentally and

I thought it was very neat You could actually sort things very quickly in Tableau Now normally you can play around with sorts and try to get things organized But there’s actually a faster way to do it I’m going to hold down my Ctrl key, I’m gonna drag sales over and make a copy of it, just like that I’m going to use our earlier trick to turn this into a negative sales Okay, I’ve got that, and now I’ve got negative sum of sales And I am just gonna quickly turn this into a discrete number, okay? And then I am going to, that did not work Select the dimension you wanna start with, and then I’m going to sort I don’t know why that didn’t work, I’m going to try that one more time, well, that time it worked I must have had the copy of it, there we go Negative sum of sales and we’re gonna make that discrete, and I’m gonna put it right in front of category There we go So wherever I move it, is where it’s going to sort it by So if I move it over here, it’s gonna sort of within each, put the states within each category and move it over here It’s gonna do a sort within each whole region And if I do it up here, it will sort it overall You can kind of see it’s quickly an easier way to sort things out If you don’t wanna see it, obviously you can hide this But it will still work as far as the filtering, I wish I didn’t hide it Here we go, I’ll unhide the whole thing, there we go You can hide it and play with that a little bit more I’m gonna move on, because l need to keep going Now that we’ve done that, I’m gonna take this to the next step I’m gonna write a series of calculations over on the side here Sort all, sort by category, and sort by region And if l look in here, l have a parameter called sort within and it’s right down here Let me show you what’s in it It’s got all region in category or the options in this parameter l have this parameter turned on, it’s right over here And then l created these calculations Sort by all does, if the sort within value is all, then show the negative sum of sales otherwise null Likewise with category, same thing If it’s a category show that also zero I then put these calculations in between each part Now I’ve given control to my user, where it’s set to all, it will sort them by all If I sort it by region, it will sort it within the region If I sort it by category, it will sort it within each category Yes, we have a question >> Steve wants to know if your workbook will be available? >> Yes, I can make my workbook available, definitely Yep, I will do that All right, I’m gonna continue on, 19, move the axis A lot of times what we find is we want one of the axis to be on the top So right now I’ve got my axis down here at the bottom, I wanna move it up to the top If you go up to Analysis and go to Table Layout and go to Advanced, there’s a box right here that says show innermost level at the bottom of the view when there’s a vertical axis If you uncheck this, apply it, it will actually move your axis up to the top Quick way to get your axis moved up to the top The next one is very popular with our financial people You can actually change your shipping date or any other date to a fiscal year Find the date in the left-hand side, right-click on it, go to default properties, fiscal year start And you can change when the fiscal year starts So if we wanna make it July, we can make it July And you’ll notice that all of our years now say fiscal year from 2015 to 2019 Any other questions so far? All right, we’re gonna keep going Change the discrete months appearance So right here, we’ve got all of our months in here But if we wanted to put this in a dashboard, maybe we want those months to be a little smaller so we have more room You can do this very quickly by right-clicking on the month label, formatting it Went over to here and date is set to null right now, I am going to set it to abbreviation And now I have a lot more room for my visualization on my dashboard You can do the same thing with continuous months So we have continuous charts here and the months are so big you can barely see them, but you can change the way they look as well

You’ll notice up here that month is continuous If you right-click on here and you say Format, and the date’s right now look like M, M, M, M If you take out one of those M’s, it will actually turn everything into an abbreviation for you You can quickly shorten down the name of the month, but a continuous month as well Next step, now we’re working on continuous months and we’ve made a bar chart When you make a bar chart with month, it puts the label on the very first month It thinks that the label should be on February 1st, May 1st So what that ends up doing is it moves our label right between the bars and it makes it really hard to figure out which one that is A quick and easy way to fix this is to make it a calculation by double-clicking it, and simply add 15 Months have 30 days, if you add 15 days to it, it will shift all your month labels to the middle of the bar Nice trick if you’re trying to get things to line up correctly There’s another way to do dual color I showed you the first two ways, but there’s also a really quick way to do it What if I wanted to color this chart by category and subcategory? You can do this by clicking on Category, holding down your Control or Command key, clicking on Shift mode, so that they are both highlighted And hold down Control, drag them to Color, and it will automatically color the chart by both of them at the same time, quick and easy way to do that Next tip, we’re right in the middle, hopefully my time is going well here We want to be able to show the headers If I put this visualization into a dashboard, a lot of times what will happen is this November 2018, number will bump up against the top or even go off the edge of the screen because there’s just simply not enough room How do I make enough room on my dashboard so I could always see the labels? Well, there’s a trick for that You can right-click on the left axis and add a reference line And actually before we do that, let me stop for a second I’m gonna create a calculation, and I already have in this case to make things go faster Where I take my sales and I multiply it by 1.1 to add 10% to the sales I add this to my details which is right here, sales plus 10% in my details And I’m gonna create a reference line there I have the reference line for the entire table You can see my reference is starting to pop up in the background I’m going to make it my summer sales plus 10% And I’m going to make it the sum And actually, yeah, let’s do it per cell, per cell’s probably a little better Turn off your calculation and your label, turn off your line Right now, I just wanna show you where the lines are You’ll notice it’s got the line right here, and it’s just a little bit above the maximum value I’m gonna turn it off, I just wanted to show you where it was I’m gonna say OK And what that does is it forces a line 10% above each of the bars And that way, if you start getting really large bars like 200,000, that extra 10% will force the other bars down and make room for your label The other nice part about this is I am not forcing the axis to have a range If I did that manually, that range would stay there And if I locked it at 160,000 and we got a 200,000, it would go off the edge of the screen So this is dynamic, it just simply adds 10% to each of your sales values and keeps everything down 10% from the top of the screen and gives you room for your labels There’s not really a way to show this, but I can show you a trick to finding it You can add custom shapes and custom colors to Tableau But you need to know where to put them To find it quickly and easily, you can go to the file menu And go to repository location and it’ll automatically open up a browser window directly to your location This is very useful if you’ve got a [COUGH] secondary home drive and you’re not using your My Documents folder on your desktop This is a quick and easy way to identify where Tableau is looking for all of your different resources Or your shapes which is right here, all the way down to your preferences file are all in my Tableau repository So that’s quick and easy way to find it File menu > Repository Location I’m at 27, Jeanne, do we have any other questions popping up? >> No >> Nothing coming in All right, I’m gonna keep going >> Keep going >> All right, creating an i icon Creating an i icon is actually very easy We use i icons, information icons, I should say, to provide some information or some background about the dashboard But we’ve never really shown anybody how to make it so I thought it’d be useful to show you how we do it The easiest way to do it is to grab your measured names and drag it to columns or rows, it doesn’t really matter

I’m gonna drag it to columns Normally when you do this there’s a title So you would need to turn off the title for the workbook and there’s also usually some sub row lines on If you go to Format with your grid lines, you’ll need to turn your row divider off It’ll normally look like that, you can see the little lines there, you can just go and turn it off I go into the Size and I set it to the middle, it starts out right about here We wanna make it a little bigger, obviously And then whatever you type in the tool tip, And you hover over it, it’ll say that So you can type all the information about your dashboard into this tool tip, move this i icon into your dashboard And whenever they hover over it, they have a lot of information about the dashboard, any caveats, anything they need to know How often the data source refreshes It’s just a nice little tool Your dashboard building, so that’s how you build that When you’re working with Tableau, you may want to color or change something based on the stuff that’s already in here Now, we know we can hold down the Ctrl key and drag one of these fields down to color So I could drag sales down to color But there’s another way to do it If I wanted sales down here on color, I can hover over it and I get this little triangle in the corner You hold down the Ctrl key and drag it up to color It will automatically color my back You can grab any of the triangles on any part of the visualization Hold down Ctrl, drag it to wherever you want to and it will add it to that part of the visualization This one is a little tricky, so kinda bear with me This is a visualization showing where profit is positive and negative Now, I want to color the negative orange and I want to color the positive blue but if I drag some of profit down to color Even if I try to make this two colors it won’t split it up for me It’s not doing it the way I want to and that’s because it’s continuous There’s gotta be a better way to do it and there is So I’m gonna drag this up there The easiest way to do this is to duplicate profit I’m gonna hold Alt+Ctrl, and create duplicate of profit up there So now we have both visualizations When you have two pills on columns or rows like this you’ll get two marks guards So I’m gonna go over to the first marks guard, the top one That one is blue which is fine The bottom one l am going to change this one to the orange like that So now I’ve got the blue and the orange, but now I need to make the axes line up To do that, we go into the axis for Profit, and I am going to set it Fixed, and I am gonna have it start at 0 That’ll move the axis down to 0, and I’m guessing you can guess what I’m about to do on the bottom axis I’m going to have it end at 0, like that That’ll force the two lines together Now, there’s a catch What you’ll notice is, it looks like everything’s lined up Hey, we’ve got the beautiful chart But this profit only goes to 800, this one goes to -1,500 So we’re misleading our users You’ll need to lock in the top axis, as well, now that you’ve set it like this I’m gonna lock in the top axis at 1,500 And I’m gonna lock the bottom axis at -1,500, that way our scale’s the same and we’re not misleading our users You can also hide the title on one of these So I can go into the axis and remove profit, so it’s not showing up twice And now you’ve got a nice chart, that’s blue on top, orange on the bottom, interesting way to do this In this particular chart, we have a whole bunch of different orders by sub category So we’ve got copiers, accessories all these is sort of stuff But I want to be able to create a parameter that will allow you to choose which I’ve already done, but I’m gonna show you how to do it again I wanna be able to choose binders and have it highlight binders for me or art and highlight art like this How can I do this? Well, the first tip that I have to show you is how to create a parameter from the dimension So in this case, we created the parameter from subcategory To do that, I simply right-click and Sub-Category and Create > Parameter When you create a parameter from a dimension, it will automatically, Populate it with all the values from that dimension I went in and typed in None, just to add a None in here, said OK I then showed my parameter, which is over here, and then I wrote a calculation based on that parameter

So I have a calculation over here called Highlight, if I can find it I cannot find it, what’s the name of it? C subcategory, it’ll be right down here, there it is Sub category to highlight This is what my calculation looks like Is my parameter equal to the dimension that I’m using? That’s all there is to it, it’ll be true or false So if it’s true, I’m gonna turn on Bookcases If it’s true, It will be dark blue If it is false it will be gray This allows me to use the parameter to highlight certain things in my chart, and quickly identify them So that is two tips One is how to create the parameter, the other one is how to set up the highlight like that Context Filtering, okay, so in this case I’m looking at all of my months of sales over the course of the four years for the superstore data set Down below I have my Top 10 Customers overall But I want it, so that when I click on December 2017, I wanna see the top 10 customers for December 2017, but obviously, it’s not working You can see I’ve got this set as a filter, though, I’ve seen one customer here That’s because the bottom chart is showing the top 10 customers filter down to the top 10 customers And then when I filter it again, it’s doing another filter second They’re showing the top ten and then if there happens to be a top in that month, it’ll show those top ten people, but I don’t want to do that, I wanted to do the other way round I wanted to filter to the month first and then show the top ten How can I do that? Easiest way to do that is to go to the second chart, Take the action, which is the first chart influencing this chart And make it a context filter, add the context What that does is it forces Tableaux to do this part first, and then do the other filter This is the top ten by sales I’m gonna show you this real quick Top ten by profit ratio, sorry, profit ratio So, I’m gonna go back to my dashboard now Now, if I click on this month, it’s gonna filter to that month, and then show me the top ten Filter to this month, and then show me the top ten So it’s a quick way to get your filters to work correctly in your charts How are we doing for time, Jeanne? >> We got like seven minutes >> I better go All right, so right now I have bars and I have labels on the bars, and it’s showing up within each color But I don’t want it to show within each color, I want it to label the total So I’m gonna take sales off of the label And the quick and easy way to do this is to right-click on the axes, add a reference line for each cell And you’ll see it puts the average up here at the top of each one I’m going to label the actual value So it’s showing me the total for each one of these I turned the light off on the field below If those happen to be on, turn them off And what that will allow you to do is you get multiple colors in the bar that have the total up at the top, fun stuff Okay, right now I have a map and it’s showing colors by state but I have in my data set something called region But I want to be able to see the regions of sections It doesn’t know that region is a geographical item, Tableaux doesn’t know that It just knows it’s South-Central, all that sort of stuff You can actually tell Tableaux that it is a geographical region, by going to Geographical Role > Create From > State So we know the region is composed of states, we can go down and create it from the state When we do that, it turns it into a geographical region We can move it down to detail and pull out state and now we can see the map colored by region So that’s how to turn something into a geographical dimension Okay, next one is jitters So what we are looking at here are all the different product names within each categories So here is all the book cases, all the different types of chairs, all the different types of furnishings, and all the different types of tables I want to be able to see all these dots but it’s really hard to because they are all overlapping There’s a couple of quick and easy ways to do this The first one is to double-click up here next to sub category And it’ll create a calculated field just like we were creating a calculated field from a pill And just set it to random() If you do this, it’ll spread the dots out on your chart Now this is a really quick and easy way to do this

But one of the things I found is it tends to cluster to the left which is not very useful for me So there’s another way to do it I’m going to double click on this and edit this The next one is called index, which will go through and number each row in the data set and then modulus Modulus is if you remember math from early elementary to grade school, it’s the remainder of a division So whatever you divide by, that is how many different columns you are gonna get of jitter So if I divided by 3 for example, and hit Enter My 3 and you have a table calculation Now you have to tell it what to do the index on We’re gonna do the index on the product name Now I have three different columns of data If I wanna jitter it even more, I put in a larger number Now I have 20 jitters across my chart, and it splits all these product names into 20 individual columns so you so you can see them more clearly 40, show only the outliers So we have a box and whiskers plot here We’ve jittered our stuff, we’ve got everything out there It looks very nice but I only wanna see the outliers within each sub category There’s a quick and easy way to do this Simply hover over the box Right-click, edit it, and hide the underlying marks That’ll hide everything that falls within the normal range and leave you with nothing but the outliers for each category Okay there are multiple marks in this visualization, but these right here seem to be following in a normal range I am more interested in the ones that are outside of the range I can click and highlight several of them like this I can copy them and then I can create a new sheet And I can paste them in, and I will be able to see all the information about those outliers really quickly Nice way to analyze any outliers Okay, this is another interesting trick that I ran into I am very interested in seeing my technology This one right here, the one I’ve got highlighted I would actually like to keep this highlight view available for my users I want them to focus on the technology, how can I do that? Well once you have something highlighted, if you go up to the legend and you can, let me click and highlight that, highlight that I will turn on the highlighter, make sure technology’s highlighted, there we go And assign the highlight colors to the palette That will actually change your palette to what he highlight looks like So you highlight it up in the corner, I’m gonna undo that a couple of times Make sure your highlight option is on on your legend Click on Technology, or whichever one you want, and then once it’s highlighted, assign the highlight colors to your palette, and that becomes your new color palette Got two minutes, I’m gonna get through a couple more as fast as I can Again, the dashboard will be available at the end of the session So you’ve created your own custom shape, which is a hexagon, and now you want to color it If you go to Color and try to change the color of this, it will not change the color of this How can I get color to apply on this? When you’re using a PNG it’s black, I want a different color There’s a quick and easy way to do this, and it’s simply, double-click up here, to create a new pill Just set it to whatever you want to, I’m gonna say x And then drag that x up to color, and now you can color it by whatever you want to A quick and easy way to color something, and am I running out of time? >> Yeah >> Are there any other questions? This will be available at the end of the session for you to download I’ll make this available to all of you I have put my notes down in the caption on each worksheet, so you should be able to follow along and follow the last few visualizations as well I appreciate your time And thank you for joining us for this IT For You I’m gonna turn it back over to Jeanne >> All right, and if you wanna put any feedback in the, Chat pod, that’d be great So thank you so much, and we will send out a recording of this session, I don’t know, sometime in the next week And we also have a resource document that we’ll send out that will include a link to the workbook That what you call it? >> Yeah, the workbook as well as all the other videos >> And I think that’s about it