Forum Discussion
Filter or Slicer: include data for text contained in specific value
Anonymous
I think the second solution meets your request. you can take a look. Just the layout is slightly different from your screenshot since we can't remove subtotal and only display total.
Anonymous
I think the logics conflict.
for page, you want to display d which domain 1 is empty.
for date, you don't want to display 3-Jan which domain 1 is empty.
i think you need to align the logics.
Above is my own opinion. Since you have accepted the solution, I suggest you to open a new post and used the example you just proivded to see if any experts can provide you better solution. (It's because I think super users and community supporters seldom look the post which has a solution)
Hi ryan_mayu , thanks for the input.
The logic is: if there is a query get number in domain 1, output it's result in other domains, no matter by which dimension.
So, if show these 3 tables, might help to understand:
Rawdata:
Output Results:
No breakdown:
By Page, breakdown by Query (to show why): because there is a query "a" which landing page is "d", and "a" meet the rule that it gets number in domain1.
Reverse Explain: so that can see why Page "d" shall be displayed. Same to above one, it is because there is a record where "a" get number in domain1 and it's landing page is "d".
Same to "By Date" in previous reply.
Anyway, I sincerely appreciate your time and advise.
Will open a new post.
Enjoy the rest of your day.
H
Anonymous
I think the second solution meets your request. you can take a look. Just the layout is slightly different from your screenshot since we can't remove subtotal and only display total.
ryan_mayu this perfectly output the expect results. Thank you so much for your help and time!👍
you are welcome