Greater Than Filtering in a Discovery
I am looking to do Greater Than filtering rather than Top N, where I want to include a set of values where any one of those values breaches a threshold, but I don't want to do it at Model level (yet) I want to do it in a Discovery, and then feed it onwards into publications.
Any thoughts on how I could achieve that please?
1 reply
-
Yes, you can do this in Discovery via the advanced Filter options. On the main toolbar, you will see a button labeled Sort & Filter. Click the drop down and choose filter.
In the filter dialog, you will select the attribute you want to filter and then change the Filter Type property to Filter Above.
You will then specify the threshold you want and make sure you also pick the appropriate measure to base the filter on (it will say Measure - Default if you don't change it).
Once you have it configured the way you want it, you can press the Apply button to execute it. You will notice that right above the textbox for setting threshold, you can hard-code the value (Fixed value) or you can use a Parameter. If you want to let the user input the threshold at run-time, create a global parameter and use it in your Filter.