topic Re: Filtering on a range in App Development

Filtering on a range

jerryr125 — Sat, 16 Nov 2024 05:19:44 GMT

Question about filters:

Can you create a filter that will filter on the data based upon a measurement falling in a range ?

That is - say you want to have a filter for the value amount - the filter would have the following to select from :

Under 2

2+ - 3

3+ to 5

5+ to 10

Over 10

and if the user selects 2+ - 3 , the sheet will filter and only show results were the Amount measure is between 2 and 3.

thoughts ? Jerry

Re: Filtering on a range

vaisgaard — Wed, 10 Jul 2019 11:19:52 GMT

Hi Jerry,

Normally I would create the measure/calculation in the loadscript. Then it becomes a dimension you can filter on.

If your calculation is a dimension, then you can use ranges in the filter on tables. If you want to have a filterpane instead, then I would create that in the loadscript as well. You can do that by using if() statements.

I hope that helps.

Best regards

Michael

Re: Filtering on a range

JordyWegman — Wed, 10 Jul 2019 13:31:55 GMT

Hi Jerry,

See this example:

Table: Load * Inline [ Value 1 2 3 4 5 6 7 8 9 10 11 12 ]; FinalTable: Load Value, IF(Value >= 0 and Value <= 3, '0-3', IF(Value >= 4 and Value <= 10, '4-10', IF(Value >= 11, '11+','<0'))) as Category Resident Table; Drop table Table;

Jordy

Climber