filter on list of floating numbers

beaubellamy — Mon, 20 Dec 2021 21:05:46 GMT

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.

Re: filter on list of floating bumbers

marcus_sommer — Fri, 12 Feb 2021 10:36:40 GMT

Maybe something like this:

class(aggr(only({< Field = {">=$(lbound)<=$(ubound)"}>} Field), Field), $(clustersize))

- Marcus

topic Re: filter on list of floating bumbers in App Development

filter on list of floating numbers

Re: filter on list of floating bumbers