Freeform table totals in Analysis Workspace

Transcript

Hey everybody, it’s Doug. In this video, I just want to give you a few tips about freeform table totals in Analysis Workspace. So here’s a project and I’ve got a freeform table down here. I have collapsed some of my visualizations up here, just so that I could see both the table and also the segment drop zone up here, and I’ll get back to that in a few minutes. But in any case, the table totals that I’m talking about, say that five times fast, are these table totals right here. So you can see that we have two numbers, kind of one highlighted number, and then out of another number, which right now is the same. So a couple of different things can affect these totals, and so I want to show you what those are, because right now it just says, yeah, out of page views kind of on my site, I have for this time period, I have, you know, this 1.38 million page views during that time. So, you know, how can that number change or why would it change, I guess, is a better question. Now, one way that this number will change is if you put a segment in your panel. So if I go down here, I’m going to grab, say, weekend visits and drop that in. Now you’ll see this number goes all the way down to 241,000. But again, both numbers did that. So and this is because really, you know, you are affecting everything in that panel. And so this table is one of the things that you’re affecting. So it really kind of, you know, in the world of this panel with that segment, it is a total and a grand total. I’m going to call this a total and a grand total of, you know, the same number of 241,000. Now, the other thing that can affect those numbers or in this case, just this highlighted total here is when you add a filter. So if I go over here and mouse over this area, you’ll see this filter up here, right? If I’m not there, it’s not there. If I go here, it shows up and I click on this filter because I want to filter in this case the pages that are in this table. So let’s say I just want to show shopping pages. So shopping and I’ll hit apply. And so these are just my shopping pages. But now when we go to these totals, you’ll see that I have 48,000 page views out of 241,000 page views. So in this case, this filter is resulting in 48,000 page views, which is cut down from a grand total of 241,000 page views, which is all the pages on my site during this time for weekend visits. Hope that makes sense. So the segment affects both of these. The filter just affects the total right here and not the what I would call the grand total. Now, you’ll also notice that we have these percentages down here. So these do dynamically change. And you can see in this case that, you know, these would add up to 100 percent. So it does change, you know, these numbers and not only the numbers, but the percentages based on that filter. Now, one of the things in that filter area, if I open this back up, that you’ll see is this include unspecified or none. And so this also affects our numbers. So, you know, I can deselect that any time and apply that. And that will in some cases affect our numbers here. It didn’t affect this one because we don’t have shopping pages that, you know, are applied by this unspecified. But if there are, for example, unspecified pages and we choose to show those or not show those, then that would affect our numbers in this total section here. A place where that’s used a little more often, we cancel out of that. And if I go to here and go to something like product or I go to, you know, tracking code or, you know, any kind of an EVAR, any any kind of those things that are more conversion related. And I’m going to drag that in and replace my pages. And then I’m also going to replace page views with visits. Let me drag that over there and you’ll see here that I have unspecified as, you know, a very high percentage. And then, of course, you know, my list of products here. So in this case, it means, you know, there were 76 percent of my visits, really, where there were no products visited or no products seen. And so sometimes this is important information to know. So by default, this is checked for conversion variables, but it is by default unchecked for traffic variables like pages. So in any case, it’ll be important for you to kind of, you know, click into the filter here and see if unspecified is being included or not. So as I mentioned before, this filter does affect the one number, the total number. So I’m going to deselect that and apply. And as promised, you know, this drops down to 41,000 out of 105,000. So there’s 105,000 visits again on weekend visits. And on 41,000 of those, there was a product touched or seen. Now, you do have the opportunity to turn those off if you don’t want to see those. And you can do that for each column. So you go to the column settings, click on the gear and then you can show, you know, totals and you can show the grand total. So if I just say, no, don’t show me the grand total, like deselect that and click out here, then you see, I just have the number there. So I don’t have to maybe explain to people why that other number is not there because, you know, I don’t want to have to explain the unspecified, et cetera, et cetera. So you can just leave the regular total there. And then in some cases, you might have numbers that don’t really even make sense to add up. So you might want to jump in and say, you know, don’t even show me totals. And so in that case, it will leave them out. So you can decide whether you want to show them or not just by simply going to the gear icon in the table, really in the column. So not up here for the overall table settings, but the column settings because you do this per column. Anyway, I hope that was helpful to kind of go through these totals, talk about what they are and how to use them and hope you have a great day.