Filtering on a range

[jerryr125]

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

[vaisgaard]

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

[JordyWegman]

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