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
Let's make your request be clear.
1. you want to see all the queries that have domain 1 value.
2. you will change the query to other column and you want to see the total amount keeps the same. What's more you only want to see the rows which have domain 1 value?
Hi ryan_mayu ,
Thanks for your reply again.
You are almost correct, the purpose is to have a slicer or a way to filter the stasted idea.
Probably I will change the "Row"' from "Query" to "Page", or "Date".
So in your 2nd screen cut in point 2, it will be:
It's because Query "a" has record in domain1, so what is "a" 's resuslt in other domain? 300 in domain 2, but when breakdown to "Page", it's in page d.
Same to Date: if adding Date info:
| query | domain | page | value | date |
| a | 0 | c | 100 | 1-Jan |
| a | 1 | c | 100 | 1-Jan |
| a | 2 | d | 100 | 1-Jan |
| b | 0 | d | 300 | 1-Jan |
| b | 2 | d | 500 | 1-Jan |
| a | 1 | c | 100 | 2-Jan |
| a | 2 | d | 100 | 2-Jan |
| a | 2 | c | 100 | 3-Jan |
| b | 0 | c | 100 | 3-Jan |
The expect result is: (in 3-Jan, the "a" only get number in domain 2, but not in domain 1, as a result, the number shall not be included.
So, I thought a way to filter and slicer might be better since all the rest of data calculation will be impacted, no matter how to breakdown, or change the dimension field.
Appreciate your time and help.
H
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)
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.
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
ryan_mayu this perfectly output the expect results. Thank you so much for your help and time!👍
you are welcome