You can manually sort the dimension by clicking on the pill and move the labels to where you want them to be. I've attached a link to various sorting techniques that might help:
Hope this helps.
Joe, you aren't technically working with an Axis, you're working with a Header. Green Continuous pills create axises; Blue Discrete pills create headers. But to your problem, the easiest way to change the order of your header is to put your [Days] field on color shelf and then use the legend to reposition (drag) the days into the order you want:
The labels will stay put even after you take the field off the color shelf.
Thanks to both of you. However, neither solution seems to be working. I'm thinking that either (a) the fact that I'm using blending makes both of your solutions impossible, or (b) the fact that I'm still on 9.1 is getting in the way.
I've attached a TWBX using Superstore and a blended Excel file to illustrate. I am unable to move the date column headers on the secondary field.
ReArrangeDateNames.twbx 1.2 MB
I think this thread might be my answer...creating a second calc in the primary data source that references the field in the secondary data source. Unfortunately I have a one-to-many scenario, so I'm still investigating...
Just wanted to close the loop....this is how I solved for the issue. Because my secondary data source was in Excel, I went into Excel and added a 'book close day rank', where I assigned each day a letter.
Day-5 = a
Day-4 = b
Day 5 = j
Then I brought in the new field into my columns and it allowed me to create this:
I then hid the header with the letters. I wasn't able to do a line chart (it plotted each day as a dot but didn't connect them into the line), but this mostly works for what I need it to do.
You can also create a calculated field that does the same thing as Joe's example:
when "Day -5" then 'a'
when "Day -4" then 'b'
when "Day -3" then 'c'
when "Day -2" then 'd'
when "Day -1" then 'e'
when "Day 1" then 'f'
when "Day 2" then 'g'
when "Day 3" then 'h'
when "Day 4" then 'i'
when "Day 5" then 'j'