1 2 Previous Next 15 Replies Latest reply on Sep 18, 2019 1:35 PM by Hari Ankem

After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 11, 2019 1:27 PM

I created some dashboards in tableau desktop, and had no problems sorting them while i was building them, but once I publish them, even though the columns have that little a-z icon, if I click on any of them it does not sort the field, what am I missing? I just checked, I cant sort in the twbx file either, unless i go to sort and do it that way, but just clicking on the columns wont work.

1. Re: After publishing dashboard to server can't sort rows in table

Hari Ankem Sep 11, 2019 2:09 PM (in response to Mike Pratt)

Is your workbook connected to a datasource published on the server?
Like Show 0 Likes(0)

Actions
2. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 7:12 AM (in response to Hari Ankem)

Hari Ankem It is connected to a data source yes, it also has connections to excel files, but in the sheets i need to sort I am only using the data cource. I tried this method of using a parameter: https://kb.tableau.com/articles/howto/creating-a-parameter-control-to-sort-by-dimension however, not all of my data types are strings, so it is giving me errors. any help is appreciated.
Like Show 0 Likes(0)

Actions
3. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 7:24 AM (in response to Hari Ankem)

Hari Ankem This is the list of what I want to be able to sort by
as you can see it has dates in there as well as one field that has a summed integer value, therefore I am getting a expected string getting datetime error.
Like Show 0 Likes(0)

Actions
4. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 8:03 AM (in response to Mike Pratt)

Hari Ankem, OK after i converted the fields to string, the sort mostly works, however the sort for the ticket open ticket duration does not, probably because it is a sum, but i can't do a sum in the case statement calculation, suggestions?
Like Show 0 Likes(0)

Actions
5. Re: After publishing dashboard to server can't sort rows in table

Vikram Gokhale Sep 12, 2019 8:08 AM (in response to Mike Pratt)

Is it Live or Extract ? Approx how many rows are there in the grid ?
Like Show 0 Likes(0)

Actions
6. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 8:28 AM (in response to Vikram Gokhale)

Vikram Gokhale, extract, about 12 dimensions in rows column
Like Show 0 Likes(0)

Actions
7. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 8:53 AM (in response to Mike Pratt)

Hari Ankem, OK I have this in my CASE statement now
and this is the output I get when I try to sort by ticket duration
it is almost working, but I can't figure out why the 8,8,9 are at the bottom?
Like Show 0 Likes(0)

Actions
8. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 12, 2019 9:10 AM (in response to Mike Pratt)

Got it working. the original KB article had said that when you put the calc field in the rows column you need to sort it alphabetically, but once I cleared that out, it works just fine.
Like Show 0 Likes(0)

Actions
9. Re: After publishing dashboard to server can't sort rows in table

Hari Ankem Sep 12, 2019 9:18 AM (in response to Mike Pratt)

Well, glad to have not-helped you so that you could get to the solution by yourself.
Like Show 0 Likes(0)

Actions
10. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 18, 2019 11:42 AM (in response to Hari Ankem)

Hari Ankem, Thank you for your help, I just have one other quick question regarding the sort, it is working just fine, but is there a way that I can make it so the user can select whether to sort the field by ascending or descending order? would that be some sort of if statement using a separate parameter?
Like Show 0 Likes(0)

Actions
11. Re: After publishing dashboard to server can't sort rows in table

Hari Ankem Sep 18, 2019 12:00 PM (in response to Mike Pratt)

Yes, you will need to create a parameter that has Ascending and Descending as the two values in the list. You can then create a calculated field which uses the RANK function for measures based on the parameter selection, or for dimensions using the ASCII function.
Like Show 0 Likes(0)

Actions
12. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 18, 2019 12:39 PM (in response to Hari Ankem)

Hari Ankem, OK, couple of quick questions, I think this would be using another CASE Statement correct? Also is there a way to be able to turn the entire string int ascii without having to use left, and mid multiple times, I ask because I know there is always the possibility of the first several letters in a word to be the same and I wouldn't want the sort to get confused.

Thanks
Like Show 0 Likes(0)

Actions
13. Re: After publishing dashboard to server can't sort rows in table

Hari Ankem Sep 18, 2019 1:21 PM (in response to Mike Pratt)
Please see if this helps:

I have attached a 2018.1 workbook for reference.

Sort Data_v2018.1.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
14. Re: After publishing dashboard to server can't sort rows in table

Mike Pratt Sep 18, 2019 1:34 PM (in response to Hari Ankem)

Hari Ankem thank you for that. I also found a very similar approach, it just assigns numbers to the fields, that way it avoids the if statements, both ways work.

Thanks for the help
Like Show 0 Likes(0)

Actions