Rock U - Reporting - Reporting - Data View Filter Groups

Transcribed Video Content

Okay. So we've looked at the basics of data views, but let's dig a little bit deeper and see how we can achieve some complex filtering logic using filter groups. So filter groups allow you to take these filters and the terms describes, put them in little groups and have them work together. So it's a lot this bomb squadron here. So they while these planes are in different groups, they're all working together to meet a strategic objective. So, for example, let's take this criteria. Now, on the first time that this criteria doesn't make the most sense, but let's say you had to achieve this. So, we want to create a view that shows individuals who are married and a member or are single and an attendee. Now, you think about trying to do that with one filtration group because you do get one by default, that's that first container. That simply wouldn't be possible. You'd have to actually use two different ones. So, basically, what we're gonna do here is we're gonna have, two criteria in each group. One is gonna say, hey, they have to be married and they have to have a connection status of member. And then down below, similarly, they have to be single and an attendee. And you could be either in either one or the other one and we want to know your name. Okay. So that's gonna require two different filtration groups. So if we go into the data view, again, we get one for free and that's what this first one is here. But what we can do is we can add a filter, that's what we were doing before, or we can add a filter group. And that's gonna give us two more of these things all inside of it. Okay? So it's kind of a parent child. And what we do in our top one here is we're gonna say if any of these are true. And then down below each of these will be show if all of these are true. Okay. So the parent one is gonna be adding the or between these two and within these will be at having the and. And that'll be make a little more sense as we deconstruct this. So we have group one and group two. Okay. So here's the full thing. Alright. So on this first, one at the top here, we have, marital status is married and connection status is member. And then down below marital status is single and connection status is attendee. Now it's a little hard to kind of picture this, so let's just draw this in. So our first group is getting married and member. The second one is single and attendee. And then the master grouping is providing either one of those. So this or this. And that's how these, filtration groups work, to increase, the capabilities of data views.