Oh wow, that works beautifully! The only problem is that I created a made up example with Superstore data because I don't want to post my actual workbook. In the real workbook, the columns are not years, but "options" that can't be changed to continuous.
I'm thinking now I could make the options a numeric field (1, 2), and then change to continuous.
Would you have any other suggestions for this case?
Could you potentially mock up a sample data set for us to look at?
Yes, see attached. It's the same data as the original one I posted, except using region instead of year. I want to do the exact same thing that changing year to continuous accomplished, but obviously the same trick won't work
I created a numeric field based on region:
Then I made it a continuous dimension just like you did with year and it worked perfectly! It's maybe not the most perfect solution, but it's far superior than what I was doing. Thanks very much for your help!
(If you do have another idea, though, please let me know )
That's probably the approach I would take!
2 of 2 people found this helpful
Here is a classic approach if you need dynamic range of Bin.
Aliases part is bit troublesome, trade-off with string calculated fields.
Oh, that's a really clever solution!