I’m using the filters feature to make it possible for users to narrow down to the bulbs that meet the specs they need.
Here's an example page:
http://www.bulbdan.com/compact_fluorescent.htm
My issue is that I would like to be able to group some of the items into “clumps” (like I can do with price) rather than having to individually list each possible specification individually.
For example, in the Initial Lumens column, currently I have to create a separate filter option item for each possible lumen. But this is very tedious process to create a separate “Option” for each Product Specification. And it makes a very long list for my web site visitors to look through (I have about 25 different “Initial Lumens” values). I would like to be able to have it, say, clump them like “from 200 to 1000”, “from 1000 to 1500”, “from 1500 to 2000”, etc.
How do I do this? I know I need to insert some formula into the SQL field, but I have no idea what to enter there!
