Hello,
I use superstore to sort by Region and Sales Thresholds(Parameter), The Sort works right if I choose All Region and All (parameter option) in Threshold. But If I choose All Region and one of the Threshold, the sort was mess up. Can someone help?
I am using Tableau 10.3
Thanks
Joyce
Jan 25, 2018 1:16 PM
I didn't do anything but change the Threshold. This is what I get:
That's so weird. That's what I get. the sort didn't not work. Do you think it may something on setting?
Jan 25, 2018 1:57 PM
"That's so weird. That's what I get. the sort didn't not work. Do you think it may something on setting?"
I'm kind of confused. You pasted the same image you had in your initial post. Are you saying that you're still getting that jumbled sort, but when I run it I get the proper sort?
I didn't change anything. Are you getting your screen shot using the same workbook you uploaded to the forum? All I can say is that the one you uploaded runs the way I think you want it to run. At least it does for me.
Yes, you can see the image that I attached, it show the wrong sort, but you have the right sort. That is why I said that it's so weird.
Yes, I getting screen shot using the same workbook I uploaded. Any idea may related to setting or something else?
Jan 25, 2018 3:10 PM
I don't know what to say...
I re-created what you have in a 10.1 version to see ... well, I don't know what I wanted to see. But I did it. (For the record, the [C_Sales_Threshold] calc couldn't be a Boolean in 10.1 because of the case statement, so I just set the value to 1 instead of TRUE.)
Anyway, it works the way you want it to work in 10.1 as well. Open it in your 10.3 and see what this one does.
You ask about this being "related to settings". The settings that matter are set in the SORT as it is set on the [Product Name] pill on the ROWS shelf. I can't imagine how some other external setting that differs between your machine and mine would impact this.
I got the warning message after I change the case statement. So the Threshold didn't work anymore.
CASE [Select sales Threshold]
WHEN 1 THEN 1
WHEN 2 THEN IF SUM( [Sales] )>0 AND SUM([Sales] )<=1000 THEN 1 END
WHEN 3 THEN IF SUM([Sales] )>1000 AND SUM([Sales] )<=5000 THEN 1 END
WHEN 4 THEN IF SUM([Sales] )>5000 AND SUM([Sales] )<=10000 THEN 1 END
WHEN 5 THEN IF SUM([Sales] )>10000 THEN 1 END
END
Any thought? or it may related to version issue?
Jan 26, 2018 9:04 AM
Edit the calc and see what the error message is.
It's not error, just warning message. So I add " else 0 " But the sort still not work properly.
CASE [Select sales Threshold]
WHEN 1 THEN 1
WHEN 2 THEN if SUM( [Sales] )>0 AND SUM([Sales] )<=1000 then 1 else 0 end
WHEN 3 THEN if SUM([Sales] )>1000 AND SUM([Sales] )<=5000 then 1 else 0 end
WHEN 4 THEN if SUM([Sales] )>5000 AND SUM([Sales] )<=10000 then 1 else 0 end
WHEN 5 THEN if SUM([Sales] )>10000 then 1 else 0 end
END
Your upload workbook sort didn't work properly in my machine too. You can see below screen shot for your reference.
Jan 26, 2018 9:46 AM
The only other thing I can do is actually log into your machine and look at it there. But I can't do that.
Log a support ticket with Tableau Support.
The sort work properly after I upgrade to 10.5.
Feb 5, 2018 8:21 AM
Joyce -- That's interesting news.
I would recommend packaging up an example workbook where it fails on 10.3 and works on 10.5 and file a Support ticket. Even though it's an older version at this point, I think the Development team would want to look at this.
