-
1. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltJan 25, 2018 1:16 PM (in response to Joyce huang)
-
2. Re: Sort didn't work right after combine the filter and paramter
Joyce huang Jan 25, 2018 1:21 PM (in response to Joe Oppelt) -
3. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltJan 25, 2018 1:57 PM (in response to Joyce huang)
"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.
-
4. Re: Sort didn't work right after combine the filter and paramter
Joyce huang Jan 25, 2018 2:08 PM (in response to Joe Oppelt)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?
-
5. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltJan 25, 2018 3:10 PM (in response to Joyce huang)
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.
-
Superstore -- Sort question.twbx 408.9 KB
-
-
6. Re: Sort didn't work right after combine the filter and paramter
Joyce huang Jan 26, 2018 8:09 AM (in response to Joe Oppelt)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?
-
7. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltJan 26, 2018 9:04 AM (in response to Joyce huang)
Edit the calc and see what the error message is.
-
8. Re: Sort didn't work right after combine the filter and paramter
Joyce huang Jan 26, 2018 9:26 AM (in response to Joe Oppelt)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.
-
9. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltJan 26, 2018 9:46 AM (in response to Joyce huang)
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. -
10. Re: Sort didn't work right after combine the filter and paramter
Joyce huang Feb 5, 2018 8:19 AM (in response to Joe Oppelt)The sort work properly after I upgrade to 10.5.
-
11. Re: Sort didn't work right after combine the filter and paramter
Joe OppeltFeb 5, 2018 8:21 AM (in response to Joyce huang)
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.