Forum Discussion

golandriel's avatar
golandriel
Frequent Visitor
2 years ago

How to use a Slicer for counting distinct values?

Hi all,   I want to use a slicer to filter my data set on how many entries I have for one ID. In my example I want to know every tree that has exactly one bush in a perimeter of 100m. In my table e...
Need Help
iceparrot's avatar
iceparrot
Icon for Advocate II rankAdvocate II
2 years ago

Hey golandriel , 

according to your description you want to filter by the amount of Bushes in a specified distance, right?

If your answer is yes, you could just use a second date slicer and use the field Distance in m as an additional filter. 
I used the demo data provided by you and this is how it looks like with two date slicers:

 

 

 

  • golandriel's avatar
    golandriel
    Frequent Visitor
    2 years ago

    Hi @iceparrot,

    thanks for your reply. Not quite! I already have a slicer for the distance. If you set your slicer to 100m and your slicer for the number of bushes to 1 it would still return all 3 tree IDs. In my case I need a slicer that only returns the ID for trees with exactly 1 bush in 100m (Tree ID 3).