LinkedIn
Twitter
Hello
I’m building out a view that will show my companies three different target segments, their internal sizes as well as the overlapp between them. a user can be part of both group A and B, depending on some initial factors.
mu initial idea was to go by user_id which we have for all our user, crete 3 dimensions, one for each target segment, and then create a bunch of measures that, with differernt filters, will tell the measure what target segment that particular measure should take into consideration.
So, when I set it all up, I ended up with this table. each target group got its own row, which I cant use my filter method on.
for example, we can see that user X is part of all three groups, but user Z is only part of two. I want each user to be one row, as seen in the picture.
The LookML I wrote for this can be found here
https://pastebin.pl/view/7b8b8bcb
thanks in advance
