Hi, I've classifying different kind of address mistakes and show the amount of these classes in a bar chart. For example "addresses missing a zip", "street addresses without street name", "street address without an apartment number", "addresses with a zip 00000", etc. As understood this kind of calculation must be done by defining each rule separately and thus, a basic 'stats count by' doesn't work. I've created the cases with if-statements using one variable for each different rule. Then I put these variables in one stats statement. What I next need is the possibility to drill down to the selected bar and show the addresses belonging to the select bar in a different panel. For example the bar "addresses a zip 00000" could have 4 cases and selecting the bar would show those 4 address in a separate panel like Streetname1 A 5 00000 Helsinki Streenname2 45 00000 Tampere Streetname3 3-5a 56 C 00000 Turku Streetname4 120/3 00000 Rovaniemi Unfortunately, I haven't found any answers how to do this.
... View more