Rock U - Reporting - Reports - Weaving Data Views

Transcribed Video Content

Okay. So let's talk about the concept of weaving entities in data views. So basically, this means is that we're gonna have data views that shift their entity as we filter through data views. Okay. So let's give a concrete example. Say we wanted to have a list of all the people in a small group studying the topics of x or y. So the first thing we have to do is we have to go out and we're gonna create a data view of groups with the topic of x or y. Okay. So that's the first thing we do. We can't just start with a person data view because we don't have the ability to search all the way down in there for a group type of a small group and then also search by an attribute of what's their topic. So we're first gonna start with a data view that's searching for groups with a topic of x or y. Okay. So then we're gonna convert that and we're gonna have another data view that's based on top of that data view that's gonna say, just give me group members who are in these groups. Okay. So basically shifting our entity from being a group to being a group member. And then finally, we're gonna convert those group members to people by writing a data view that uses that that blue data view to give me people who are inside of that group member data view. So let me show you exactly how do you do that. So we're just looking at our adult member and attendees data view here. We're gonna hit edit. Okay. So you've seen before where we can say in an existing data view. Okay. And so that assumes that the existing data view is also searching for people. Okay. So that's that's fine. We've seen that before. But if we go down a little bit more, we can see that we can use a group data view or a group member data view even though we're searching for people. So this allows us to kind of bend or weave the entities in inside of our filter. So it's common as you start making complex logic that you might start filtering on one entity type and then convert it to another one. Okay? So again, we went from group to group member to person. And that's how you can weave data views together and their entities, to achieve some pretty powerful results.