-
1. Re: After publishing dashboard to server can't sort rows in table
Hari AnkemSep 11, 2019 2:09 PM (in response to Mike Pratt)
Is your workbook connected to a datasource published on the server?
-
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.
-
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.
-
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?
-
5. Re: After publishing dashboard to server can't sort rows in table
Vikram GokhaleSep 12, 2019 8:08 AM (in response to Mike Pratt)
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
Mike Pratt Sep 12, 2019 8:28 AM (in response to Vikram Gokhale)Vikram Gokhale, extract, about 12 dimensions in rows column
-
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?
-
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.
-
9. Re: After publishing dashboard to server can't sort rows in table
Hari AnkemSep 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.
-
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?
-
11. Re: After publishing dashboard to server can't sort rows in table
Hari AnkemSep 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.
-
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
-
13. Re: After publishing dashboard to server can't sort rows in table
Hari AnkemSep 18, 2019 1:21 PM (in response to Mike Pratt)
-
Sort Data_v2018.1.twbx 1.2 MB
-
-
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