Issue#23: Tableau - Pin row labels while scrolling crosstab in Tableau Server

  • When you're scrolling down a crosstab in Tableau Desktop, the leftmost row label(s) are pinned to the top of the screen so you can always see which section you're in.  This makes a big difference when you have hundreds of detail lines for each leftmost row - it allows you to always see which section you're in.


    When you publish the same cosstab to Tableau Server, this feature no longer exists.  The same feature should be added to Tableau Server.


    This idea is related to the following community forum pages. The first one has a good doc w/ screenshots to help explain -
    Locking the "pane" names on Tableau Server:
    Lost crosstab parent column pinning when published to server?:

    0 Answers

    Sorry, your answer is too short !

  • Issue#198296: Tableau - SQL Server impersonation issue

    Hi All, I've a small issue with SQL server impersonation configuration. To give the details, I'm using live connection to a MS SQL Server Database in one of my workbooks (published with impersonate via server run as account) and the tableau service account has db owner permissions to that database. When I grant a user access to that database, his access to the tableau workbook on the server works fine. However when I remove his access to that database on SQL Server, he is still able to access the workboook. Pls let me know if this is a limitation or am I missing some setting anywhere. Kindly help me.  Thank you!Surendra

  • Issue#256851: Tableau - Issue in setting up AD with tableau server

    We are in the Process of Setting up Tableau Server 9.2 with Active Directory Authentication. We have created a generic AD for that as well. Our AD team is not allowing us to provide Admin Privileges to that AD ID. They are asking for specific rights to be given to that ID. In Tableau documentation, it is not clearly mention regarding list of permission to be given to the id. Can anybody please specify that what all privileges / Access rights / Permission / Group an AD ID should have to configure that AD ID as the Administrator of  Tableau while initial setup of Tableau ?

  • Issue#906857: Tableau - Format row in CrossTab

    Hi all, I have a worksheet in below:  And I want to format the same picture with conditional  { Unit price > 10.000 then 'gray' else 'red' } but apply one measures Unit Price.How to write calculated format color in this case? Because I have very more measures, I don't want to use method create measues 0 and format every measures.

  • Issue#906858: Tableau - Format color row in crosstab

    Hi all, I have a worksheet in below:  And I want to format the same picture with conditional  { Unit price > 10.000 then 'gray' else 'red' } but apply one measures Unit Price.How to write calculated format color in this case? Because I have very more measures, I don't want to use method create measues 0 and format every measures.

  • Issue#12: Tableau - update to primary server IP

    Over this past w/e, the IP of our primary Tableau server was updated to a new VM cluster within the network.  I followed instructions in the admin guide which states when this occurs, run a tabadmin stop, tabadmin config, tabadmin start in order to update communication throughout the cluster.  None of the commands worked (including "tabadmin stop").  Anybody have any ideas as to why or what to do?  For now, we rolled back the IP change. ORD-TBL107 (primary):        Status: RUNNINGORD-TBL104 (worker):        Connection error contacting worker 1ORD-TBL105 (worker):        Connection error contacting worker 2ORD-TBL106 (worker):        Connection error contacting worker 3

  • Issue#19: Tableau - Return Nth Largest Number Across Numbers (Unsorted) for Each Row

    I've seen a couple of useful suggestions in this forum for returning the Nth largest number, but unfortunately all of them require the numbers to be sorted.  Is there a solution that would do the same with unsorted numbers?  Please see examples below:  I'm trying to find the 2nd largest score for each student among the test scores they got from the different exams.  The subjects have to be displayed in this particular order so numbers may not be sorted (at all) for all the rows. Student               Math          Science          History          English             Correct Answerstudent1              90     

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • Issue#24: Tableau - Make Server Extract Path Editable

    Some of our tableau users tend to publish extracts to the server while pointing to a local drive where the original data file reside. They later found that the refresh failed and realized that the path to the data set is the culprit. To remedy it, one has to republish a data source and replace data source. It may break the workbook and dashboard. I would propose to make the server extract path editable so that user can change it to a UNC path. This may save a considerable amount of effort from both users and support personnel.

  • Issue#36: Tableau - Has any one seen this error retrieving records from SQL Server

    There is about 50000 record in this table I am trying to get information from... If I narrow down the range it fine... but if I request all of it I get this error... Thanks.  CARLOS TRIVINO | Director, Information Technology905-875-0708 ext.332   Fax: 905-875-55191-375 Wheelabrator Way, Milton, ON, L9T3C1 "This email and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail.  

  • Issue#44: Tableau - Expose the Server File Store files on the web for editing

    Allow people to review and edit objects (Excel, CSV, etc.) that are in the File Store. Drivers:They're up there anywaysI want to see what's thereThere are a lot of web editing tools Objectives:Keep it simpleExpose this content for people Benefits:See what's thereMore collaborative

  • Issue#54: Tableau - Ability to Rename Workbooks on Server

    Add the ability to rename workbooks on server. If you need to change the name of a workbook, you must republish from desktop. There should be a way to rename a workbook without republishing (this is very annoying if the workbook is large).

  • Issue#74: Tableau - Tableau Data Engine Error: 8 with all published views on server 9.1.1

    Recently we encountered issue with below error for all views. This impacted all business users in QA instance. We were not able to figure out what was the root cause. We have open case with Tableau as well. Even though, we were able to resolve issue but still would like to hear from anyone who had similar issue and know the root cause so that we can avoid going forward. "An unexpected error occurred. If youcontinue to receive this error please contact your Tableau ServerAdministrator. DataSourceException: Tableau Data Engine Error: 8: An error has occurred inIPC_Socket::Recv(buffer length=16) An existing connection was forcibly closedby the remote host 2016-01-20 00:25:41.372 (Vp7UBawQOk0AAAho0GQAAAJO,1,1) Would you like to reset the view?' Resolution: On two node architecture 1. Stop Services2. Move all services from Worker Node to Primary Node except Data Engine; File Store; Repository3. Save and start services; After start check if all views are working as expected, i

  • Issue#83: Tableau - Export crosstab option via tabcmd using export (or) get commands

    Hi Team, We have a requirement to send the data available in dashboard through email to user in same format visible online(browser). When i download cross-tab through browser manually data comes in expected format. where as with export (or) get commands with tabcmd format is messed up in exported csv file. Attached excels for reference.Sample_data.csv -expected output (via browser)Sample_data_tabcmd_get_export.csv -incorrect output (via tabcmd) Appreciate if anyone has workaround for this requirement.  Thanks,SD

  • Issue#84: Tableau - Put X-Axis Labels UNDER graph, not in header!

    Am I missing something? I've dragged the x-axis labels from the header area over and over again to try and put them under the baseline where they should be, rather than in the header. However, I either accidentally remove all x-axis labels, or duplicate them in the header region. The closest I've come is to have a copy of the header labels below the graph, but the labels under the graph keep segmenting too granularly, and do not reflect what I want (group-wise). Anyone have a tip? I find it strange that by default you cannot place x-axis labels UNDER graphs... First attachment - exactly what I want for the x-axis, but it should be UNDER the graph. Second attachment - all I can figure out how to do. And when I try to hide the top date, both top and bottom disappear. I don't want the dates segmented within the 3 groups anyway, there should only be three groups- one for each date. Why is this so difficult?

  • Issue#87: Tableau - Query on publishing workbook inside tableau server.

    Hi Sir/Mam,   For publishing workbooks, currently am doing it through the developers desktop tool (Developer Local Machine). Please let me know the steps for publishing the .twbx files directly in Tableau Server (Remote Machine). Thanks in advance. Regards,Vasu

  • Issue#110: Tableau - Row level security set up

    Hello all. Since we do not have a security table in out data source we will have to deploy the manual security filtering. We have a requirement whereby users can only see the data for dashboard for their region: - Asia- Europe- Americas- WW Setting up row level security for each region is very simple. How can I apply the WW team to all regions?  Unless I missed something it seemed I could only assign a security group to a single Region data element. How can I assign WW team to all 3 Regions?

  • Issue#111: Tableau - Tableau Server 9.2.2, 9.1.4, and 9.0.10 Downloads are no longer available

    Tableau Server 9.2.2, 9.1.4, and 9.0.10 have been removed from the downloads due to a critical fix.  If you installed one of these versions, rollback immediately using the Rolling Back to an Earlier Installation of Tableau Server instructions.  Please subscribe to the RSS feed for updates on new versions.

  • Issue#1983: Tableau - Dashboard Action was not worked on Server

    Dear experts,I have created a map dashboard with user filter for each region  and i have created another dashboard to show up detail for chosen region  by using dashboard action --> Filter. However, when i signed in from web interface by my role( for example - North region), i just see the data for my region but i am unable to see the link to show up detail dashboard from map dashboard This is on desktop version --> I can see the detail to province link   This is on web interface - I am unable to see detail to province link:  Has any advice for this?? thank in advanced  Regards,Michael

  • Issue#6378: Tableau - Access Drivers compatibility with Tableau Server 9.2

    I used to have Tableau Server 8.0.3 (32-bit version) along with 2007 32-bit and 2010 32-bit Access Drivers installed. Now we have upgraded to Tableau Server 9.2 64-bit. Do I need to uninstall both the 32-bit Access Drivers and install 64 bit 2010 Access Drivers? (We don't have any other office components on that machine) Thanks,Su Ve

  • Issue#10493: Tableau - After publishing tableau server data source, the alias is no longer available and doesn't

    This seems to be a bizarre issue I encountered today after publishing a data source to Tableau Server. While on my desktop I had an alias on a measure name. After publishing to Tableau Server, this alias disappeared (as expected). However, now I'm attempting to create a new measure with the same name as my alias, and it doesn't let me "A field named "X" already exists."   However there seems to be no way for me to access the previous alias in order to delete it. Anyone know how to workaround this issue?

  • Issue#14473: Tableau - Tableau server slowing down an Oracle query...why?

    I have an oracle query that runs in about a half a second when I run it without tableau (run in Toad, both from my laptop and also tried it from Toad installed on the Tableau Server, to rule out bandwidth issues). When I publish the custom sql to the Tableau server, the same query takes between 9 and 16 seconds. I'd like to understand why the query takes so much longer from within Tableau. Any ideas?Thanks,Jack May

  • Issue#18044: Tableau - Tableau Server - Reassigning licences

    Hi, We are just getting our Tableau Server environment set up, and have bought our first batch of named user licences. Ultimately, our TS site is going to be external facing. However we need to do some internal testing first. Is it possible to assign this first batch of user names licences to internal users first, and then when they are finished to re assign these seats to our external clients? Or do Tableau work on a basis that once the server licence is used it cannot be re-assigned? Thanks in advance. Joe

  • Issue#21151: Tableau - Contingence / Test Server

    Hi, the question is, its possible to install an a contingence server or test with the same key that we purchease from a tableau server? ( 10 licences in server)

  • Issue#23082: Tableau - Mapping Server Name ???

    Quick Question. Is there any way to map/bookmark the name of server in Tableau?I have multiple server name to connect thru Tableau, but at each time, I need to go to my email to copy server name and paste it to the box.Any bookmark or mapping server name type of function available ?? Thanks,Shin

  • Issue#24007: Tableau - How to avoid popup asking database credentials after publishing the Dashboard into Server?

    Hi All, I have published my Dashboard into server. when i am opening it, its asking database credentials every time, please suggest me how to avoid it. Regards,Ashok

  • Issue#30014: Tableau - Percent over specific row - LOD?

    I thought I could just use a LOD expression for this one, but it's proving to be more difficult than I thought  I have the following dimensions:CategorySubCategoryType Measure = "COUNT of Color" I am just building a table and need to show the % of Color by 'SubCategory'.  Since Tableau will show the % by the last Row added, it is showing % by 'Type'. I've tried creating LOD's with no luck, is there another way? Thanks! Toni

  • Issue#34897: Tableau - Tableau auto-populate formulas with whatever is currently in row/column field

    Hey guys, So I want to print R values into the title of my sheet and I use the following: cov - (1/(SIZE()-1))*   WINDOW_SUM(     (SUM([x]) - WINDOW_AVG(SUM([x]))) *     (SUM([y])  - WINDOW_AVG(SUM([y])))  ) R - [cov] /(WINDOW_STDEV(SUM([x]))*WINDOW_STDEV(SUM([y]))) Is there any way to build these formulas such that I can throw a measures ([x], [y]) into the row and column fields and Tableau with automatically change the names of the measure in my calculations to match? So if I wanted measure a in the rows and measure b in the columns, when I drag those measure up there, all the [x] in the calculations would automatically change to [measure a] and the same with [y] to [measure b]. Obviously I would like to avoid having to build out every single version of these calculations for each combination of measures... Thanks!

  • Issue#41025: Tableau - Sorting Blended Data - Multiple Axis Crosstab

    I have a calculated field: Percent to Budget = SUM([Sales])/SUM([Budget]).  Sales and budget are located in two data sources.   I'm using a multiple axis crosstab as I need to be able to color individual columns separately, but I can't sort the data on "percent to budget", it doesn't show up in the "Sort by Field" list.   Any ideas on how I can sort by this field? 

  • Issue#41121: Tableau - How to disable breadcrumbs in server

    Do we have any workaround to disable or hide breadcrumbs in server using API