Forum Discussion
Filter only IDs on Drill through
Consider a table like this:
| ID | QUESTION | ANSWER |
| 1 | Yes or no? | Yes |
| 1 | Age | 24 |
| 2 | Yes or no? | Yes |
| 2 | Age | 27 |
| 3 | Yes or no? | No |
| 3 | Age | 30 |
I have an treemap that returns a count of answers of an filtered question. I need to do an Drill Through that don't shows only visuals with the answer that i drilled, but shows the other answer these people answered. Like drill onto the count of Yes answers and return the 1 and 2 answers of Age.
2 Replies
Hi MatheusPolesca1 ,
Here are the steps you can follow：
1. Select [QUESTION] – Transform – Pivot Column.
Values Column – Answer
Aggreate Value Fuction – Don’t Aggregate
2. Result:
Not drilled through.
It's been drilled through.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
That's super helpful, and I'm already thankful!
Now, with this, there's a solution to show the percentage of the count for the node considering that the node is dynamic? (Sometimes the age is first and sometimes last)
