Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm sure there is a simple function that will allow me to do this, but I can't quite find it.
I have a field that has random floating numbers (0.123, 0.932, 1.132, 1.4332, 3.43, etc) . I would like to be able to create a filter to only show the values above a threshold, where the filter only allows a subset of values to select (say from 0.5 to 1.5 in steps of 0.1 or 0.05). The filter will select this threshold and allow all values above to be displayed, such that a filter selection of 0.55 will only show the field where the value is above this threshold.
The Class function is almost what I'm looking for but I want the upper bound of all values to be the maximum value.
Maybe something like this:
class(aggr(only({< Field = {">=$(lbound)<=$(ubound)"}>} Field), Field), $(clustersize))
- Marcus