Help

Help me create a filter for a range of numbers

Topic Labels: Formulas
1713 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dean_Tan
4 - Data Explorer
4 - Data Explorer

Hello all,

I have a range of random numbers. For example: 7, 13, 24, 28, 32, 35, 37, 40, 42.
I need a filter that filter numbers into separate section. For example, “1st section” includes 1, 3, 5, 7, 9 then the “7” above will be filtered into that “1st section” and so on.

Is there anyway to do this with formula? Like if the value is “7”, it will have the “1st section” text or something similar

2 Replies 2

Hi @Dean_Tan,

I dont get your question. Please be more clear so we can help you. A screenshot would be great.

BR,
Mo

If you are talking about a field number, you could:

  • Create Views and add the desired Filters, for example, Number is smaller than 10.
  • If you want to separate by tens, you could add an extra Formula field dividing by 10, and then Gouping by it, so you’d get groups of tens. Of course could create Views too.