What is the best way to segment multiple ranges from a single range?
I'm building an application that requires individual accounts to be segmented by revenue. I’m trying to find the easiest way for the User to create these segments. This task involves breaking a single range of revenue — in this example $1-$10,000 — into multiple smaller ranges.
The relationships: - The application has a revenue range (the larger one). - Each segment has a revenue range within the application revenue range. - Each Account has a monthly recurring revenue number.
Above is my current solution—a table with the name of the segment and fields for the user to enter low and high ranges for the segment. I'm concerned that this will come off as confusing and it doesn't show where those ranges fall within the total range within the application.
I’ve considered moving to a series of sliders within a slider—perhaps how Photoshop handles gradients, but am worried that it is going to come off more confusing.
Has anybody tackled this problem before or have thoughts on the best way to solve it?