-
1. Re: After publishing dashboard to server can't sort rows in table
Is your workbook connected to a datasource published on the server?
-
2. Re: After publishing dashboard to server can't sort rows in table
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.
-
3. Re: After publishing dashboard to server can't sort rows in table
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.
-
4. Re: After publishing dashboard to server can't sort rows in table
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?
-
5. Re: After publishing dashboard to server can't sort rows in table
Is it Live or Extract ? Approx how many rows are there in the grid ?
-
6. Re: After publishing dashboard to server can't sort rows in table
Vikram Gokhale, extract, about 12 dimensions in rows column
-
7. Re: After publishing dashboard to server can't sort rows in table
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?
-
8. Re: After publishing dashboard to server can't sort rows in table
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.
-
9. Re: After publishing dashboard to server can't sort rows in table
Well, glad to have not-helped you so that you could get to the solution by yourself.
-
10. Re: After publishing dashboard to server can't sort rows in table
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?
-
11. Re: After publishing dashboard to server can't sort rows in table
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.
-
12. Re: After publishing dashboard to server can't sort rows in table
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
-
13. Re: After publishing dashboard to server can't sort rows in table
Please see if this helps:
I have attached a 2018.1 workbook for reference.
-
14. Re: After publishing dashboard to server can't sort rows in table
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
