# Filter with aggregation and values greater or less than

**URL:** <https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854>\
**Category:** Ask for Help\
**Created:** [February 22, 2022, 7:47pm UTC](https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854 "2022-02-22T19:47:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NickP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nickp/32/37966_2.png) [@NickP](https://community.glideapps.com/u/NickP)\
**Post date:** [February 22, 2022, 7:47pm UTC](https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854/1 "2022-02-22T19:47:47Z")

</div>

Hello. Please help me to understand the design of filters.  
I work on projects in real estate.  
There is a provision to create filters with the area of objects.  
Each object has an area.  
The filter has these values:  
Suggested square footage: not important / up to 6000 sqm / up to 11000 sqm / up to 21000 sqm / more than 21000 sqm

How to aggregate the values in the card under these parameters.  
Used if the else and single value, but I don’t understand how it should work.  
How to clean filter options compare them output under this card?  
Example: warehouse area is 5999 it is less than 6000 sqm. How to display this card when a visitor selects a value up to 6000 sq.m.

And how to display the card if the visitor selects a value greater than 21000 sq. m.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 23, 2022, 12:48am UTC](https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854/2 "2022-02-23T00:48:31Z")

</div>

Interesting question. Let me draw something out.

The main problem here is an object can belong to multiple filter categories.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47378a1860cb107af41de9e827a87e9c122cacd3.png)

Up to 6000: Only contain [1]  
Up to 11000: Contains both [1] & [2]  
Up to 21000: Contains [1], [2], [3]  
More than 21000: Only contain [4]

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae5ae104dffcee17a372461129d5a747e276c1a4.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c076043b3481a17eb34443b0f42ddf83acfe67e0.png)

My approach is to use an If Then Else column to give all corresponding categories based on the size, like the screenshots above, then use a final split text column to split it out.

Then, you use that split text column result as your “filter” column.

---

<div class="post-metadata">

**Author:** ![NickP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nickp/32/37966_2.png) [@NickP](https://community.glideapps.com/u/NickP)\
**Post date:** [February 23, 2022, 10:48pm UTC](https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854/3 "2022-02-23T22:48:58Z")

</div>

Thank you. Can you tell me if it’s possible to implement a similar filter through choice? I will have several such filters. In app it is possible to make only one filter.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 24, 2022, 12:02am UTC](https://community.glideapps.com/t/filter-with-aggregation-and-values-greater-or-less-than/38854/4 "2022-02-24T00:02:17Z")

</div>

Do you want to implement multiple-choice for this? (I mean for a single filter can you do multiple choices)

If it’s just a single choice, then you don’t need the split part. Just add a filter condition like this:

“Size Choice” is included in item’s “Size Filter”.