Skip to main content

#Tableau47 discussing

I’m attempting to connect Tableau to a remote MySQL database from mac. On Windows, I was able to set this up by installing the ODBC driver and VStudio, and no issues--connection successful.

  However, I keep encountering errors on mac when trying to configure or establish the connection despite following instructions and using the drivers on Tableau website.    

Any insights would be appreciated.    

2 answers
  1. Mar 11, 1:26 AM

    @A.Mohammed Abubakar

     

    Hi, in Mac there are two things. If you are using hostname, make sure to use the full qualified name or the ip.  

    Hi, in Mac there are two things. If you are using hostname, make sure to use the full qualified name or the ip. Also, which driver did you installed? I recommend you install the 8.0.

    Also, which driver did you installed? I recommend you install the 8.0.33 release of the driver.   

     

    If you are using Tableau Desktop for silicon processors use: 

    https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.33-macos13-arm64.dmg

     

     

    If using Tableau Desktop for intel install this driver: 

    https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.33-macos13-x86-64bit.dmg

     

     

    Finally, you may test with this public mysql: 

    https://docs.rfam.org/en/latest/database.html

     

     

    To avoid conflicts make sure there is only one driver installed. 8.1, 8.2, 8.3, 8.4 and 9.x release of the drivers may not work. 

     

    When it says password none, it means without password. 

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

Tableau doesn't seem to give the option to pick which month of the year 

 

I'm running Tableau Server 2025.1.7 on premiser server with Windows Server 2022  

Looked in to using windows task scheduler and tabcmd but it requires to put in the script the admin login and password. The password will change so this defeats the automation goal  

Is there a way to schedule an extract refresh at specific times in the day, weekdays, months of the year?

 

 

 

#Tableau

1 answer
  1. Apr 10, 6:07 PM

    Hi @Vinh Ton

     

    In Tableau Server, scheduling is limited to daily/weekly intervals—there’s no native option to pick specific months. 

    Options: 

    •  Create multiple schedules (e.g., separate weekday + time combinations) 
    •  For advanced control (months, specific dates): 
      •  Use tabcmd / REST API + external scheduler

    About credentials issue:

    •  Instead of hardcoding password, use: 
      • Personal Access Token (PAT) (recommended) 
      •  Or Run As / service account with stored credentials 

    Best practice: Use PAT + Task Scheduler for secure, flexible automation

     

    If you find this helpful feel free to mark it as Best Answer !!!! 😊 

    Thanks and Regards. 

0/9000

I want to create a custom legend for the box plot where I see the open black circle as the Hold Time and the closed blue circle as the Turn Around Time. Thanks!  

 

 

How do I create a custom legend for this Box Plot?

 

 

 

#Tableau Desktop & Web Authoring  #Tableau

1 answer
0/9000

Hi, 

 

I am reconciling the tableau formulas in my workbook and there are few metrics define and but the data of these metrics showing wrongly. 

 

Tableau Calculations Needed - Logic not working -Data Mismatch

 

 

1. Immediate Approval-without changes : 

COUNT(  

IF [Status] = 'Approved'  AND CONTAINS(UPPER([Comments]), 'APPROVED')   

   AND CONTAINS(LOWER([Comments]), 'approved')   

   //AND CONTAINS([Subject], 'RESIS Approval')   

   AND {fixed [Latest Version: Full Title],[Status]:count([Comments])} <= 1  

THEN [Document Number]   

END ) 

 

Total is 7 BUT its showing as 6, the formula is not working  

 

2) % Immediate Approval is # Tickets/ Immediate Approval-without changes and this is showing the wrong values 

 

3) Avg Turn around for Immediate Approval-without changes : 

 

i am using this formula  

{fixed [Latest Version: Publication Lead Function]:avg(  

 

IF {FIXED [Document Number],[Latest Version: Publication Lead Function]: min({fixed [Document Number],[Latest Version: Publication Lead Function]:[Immediate approval (no changes requested)]})} = 1   

 

THEN DATEDIFF('day', [Created Date], [Completed Date])  

 

END  

 

)} 

 

The values are showing wrongly,  

Ex:  1,10,9,10,10,8,13  Avg is 9 days but its shwoing wrongly. 

 

4) Average Turn Around Time- Changes Requested (days) 

 

{fixed [Latest Version: Publication Lead Function]:avg( 

IF {FIXED [Document Number],[Latest Version: Publication Lead Function]: min({fixed [Document Number],[Document Scope],[Assigned To: Full Name],[Latest Version: Publication Lead Function]:[Approval (changes requested)]})} = 1  

THEN DATEDIFF('day', [Created Date], [Completed Date]) 

END 

)} 

 

This is nothing but approvals anything more than 1 in comment,  the values are showing wrongly. 

 

Need some guide to validate these formulas and need help, Thanks 

2) 

 

 

#Tableau Desktop & Web Authoring  #Reports & Dashboards  #Tableau Cloud  #Analytics  #Formulas  #Tableau  #Tableau Public  #Tableau Prep  #Tableau Next

2 answers
  1. Apr 9, 1:50 PM

    @i p

     

    Hi, here are my comments. I created an approved status calculation:

    {FIXED [Document Number]:

    IF MAX([Status] = 'Approved'

    AND CONTAINS(UPPER([Comments]), 'APPROVED'))

    AND COUNT([Comments])> 1

    THEN "Approved with Changes"

    ELSEIF MAX([Status] = 'Approved'

    AND CONTAINS(UPPER([Comments]), 'APPROVED'))

    AND COUNT([Comments])= 1

    THEN "Approved without Changes"

    ELSE "Not Approved"

    END

    }

     

    With this simple variable, you can merge all the info in a single sheet, using simple COUNTD.  Finally, for the turn around, you may use:

    {FIXED [Document Number]:

    IF MAX([Approved Status])<>"Not Approved" THEN

    DATEDIFF("day",MIN([Created Date]),MAX([Completed Date]))

    END

    }

    Finally, you may get a Dashboard like this: 

     

    Hi, here are my comments.

     

    Note that to simplify filtering, I created a Min Create Date field. 

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

I have a requirement adding tool tip on dimension, whichever field you hover over it has to show entire row information as a tool tip. Need help to achieve that.I am attaching workbook with sample data 

 

#Trailhead

3 answers
  1. Apr 3, 7:20 PM

    Hi @Madhavi Vontikommu

     

    If your tooltip isn't showing on a dimension in Tableau, the setup is usually correct. 

    Key point:

    • Tooltips don't work on dimension headers (Rows/Columns)
    • They only work on marks (cells/text area in the view)

    What to do:

    • Just hover over the cell/text area, not the dimension label.

    Suggestion:

    • Make it a text table and increase cell size so it's easier to hover.

    This is a Tableau limitation, not a configuration issue 

    #Tableau

     

    Hope you find this helpful !!!! 😊 

     

    Thanks and Regards, 

    Pooja Bhattacharya

0/9000

I have a Tableau Cloud site and I need to export its meta data to give to my IdP.  When I click Settings, then Authentication, then New Configuration, there is no button to export the metadata of the Tableau Cloud site to give to the IdP.    This wasn't the case before. How can I find this meta data (and certificate)?    I've spent at least an hour searching for how to find this and of course, AgentForce was of no help at all.    Also, I believe the metadata for Tableau Cloud is different than Tableau Cloud Manager. Is this correct?  

2 answers
  1. Apr 4, 1:11 AM

    Appreciate the help Diego. The problem I'm having is that I can't get to the step where I can provide the Tableau Cloud meta. After step 4 (on the Tableau Cloud site), when I press "Save and Continue" I get "An unexpected error occurred while processing your request. Try again".  No details and there is no button that tells you where to see what the error was. 

     

    Let me go back to my IdP and make sure they are generating the metafile correctly and then I'll report back. In the meantime, if you know how where Tableau Cloud stores it's log file, that would be helpful.

0/9000

I have CRMA recipe and I want to connect this recipe's output to Tableau Next. What are available options and what is the best approach? Thank you in advance. 

 

#Tableau  #Tableau Cloud  #Tableau Next

2 answers
  1. Feb 26, 9:37 PM

    @Nimish Vaidya

     

     

    Data Cloud

     

    Hi, currently (Feb 26, 2026) you would need to create a DLO from a recipe (requirement for the recipe is to have one input, and one output) 

    https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_output_results_dc.htm&type=5

     

     

    Once, you have run your receipe, that will create a DLO in Data 360.  I recommend you, that after creating the DLO, you also create a Custom DMO. 

     

    a. In Data 360 (Data Cloud) go to Data Lake Objects tab, and select your newly created DLO  

     

    Data Cloud Hi, currently (Feb 26, 2026) you would need to create a DLO from a recipe (requirement for the recipe is to have one input, and one output) Once, you have run your receipe, that will create

     

     

    image.png(Wait some minutes)image.png

     

    c. Save and Close. 

    d. In Tableau Next, Create a Workspace, then a semantic model using your DMO, and you are ready to create vizzes. 

     

    Why I recommend you to use the DMO? 

     

    DMO are more flexible than DLO.  So, let's say you want to change your datasource from the output of the recipe, to a database connection.  In that case, you would only need to create the Data Stream, and the respective DLO, map the DLO to the existing DMO, and remove the mapping of the old DLO.  That way, using the DMO is easy to change the source of the data.  If new fields, just add new fields to the DMO and add the mapping of the fields from the DLO.  

     

    Tableau Cloud

     

    Let's say, you have some kind of hybrid deployment Tableau Cloud - Tableau Next - Tableau CRMA (so you are using the data in Tableau Cloud and Tableau Next).  If this is the case, you can output your recipe to Tableau Cloud and then you can use Tableau Next to connect to your Tableau Cloud Published Datasource. 

    https://help.salesforce.com/s/articleView?id=data.c360_a_sl_data_models_create_from_pds.htm&type=5

     

     

    image.png

     

    image.png

     

    Why this approach? (you may still create the DLO-DMO and connect Tableau Cloud to the DLO-DMO you published).  Because, the cost of Data Cloud queries will be reduced when running Tableau Cloud queries and results sent to Data 360 (Tableau Cloud would execute the queries, and the result is sent to Data 360).  Instead if you use a Tableau Cloud to Data 360 Connection, the cost of queries would increase (because Data 360 would run the queries against the DLO/DMO, that involves Data 360 credits running the queries), and the result sent to Tableau Cloud. 

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

Hi everyone,

currently Tableau does not allow for Rich Text formatting (such as different fonts, marking colors, bold/italic) within text fields or dashboards. The ability to highlight important information, create more engaging instructions in a visually appealing way would be extremely valuable for dashboard design.

Are there any plans to introduce Rich Text support in Tableau? I believe many users could benefit from enhanced text formatting options. 

 

Example:

Feature Request: Support for Rich Text in Tableau

 

 

 

 

If there are existing workarounds or discussions on this topic, I’d love to hear your experiences!

 

 

#Tableau Desktop & Web Authoring  #Tableau Server  #Tableau  #Tableau Public

4 answers
  1. Apr 3, 12:16 AM
    Hey, could you share your workbook so I can take a closer look?
0/9000

Hi, 

 

I am trying to define a a formula in tableau.  

 

1. Avg Turn Around Time for Approval (in days) 

2. Median Turn around Time for Approval (in days) 

 

I have a approval criteria defined already  

 

COUNT(  

IF [Status] = 'Approved'   

   AND CONTAINS(LOWER([Comments]), 'approved')   

   AND CONTAINS([Subject], 'RESIS Approval')   

   AND {fixed [Document Number],[Document Scope],[Assigned To: Full Name],[Latest Version: Full Title],[Latest Version: Publication Lead Function],[Latest Version: Status],[Subject],[Status]:count([Comments])} <= 1  

THEN [Document Number]   

END ) 

 

But i want to calculate these fields based on my approval criteri only , this is not about the date diff of created date and completed date  

 

The turn around time for approval based on my approval condition  

 

1. Avg Turn Around Time for Approval (in days) 

2. Median Turn around Time for Approval (in days) 

 

Thanks and appreciated your help. 

Avg Turn Around Time Tableau Calculation

 

 

 

#Tableau Desktop & Web Authoring

14 answers
  1. Mar 26, 10:17 PM

    Hi, 

    Here are the results after adjusting the FIXED level of detail in the calculated field. 

     

    1)Use Fixed. 

    Hi, Here are the results after adjusting the FIXED level of detail in the calculated field. 1)Use Fixed.

     2)Use Include image.png

     

    *The FIXED function uses a fixed level of detail, while the INCLUDE function aggregates dynamically based on the contents of the view.

0/9000

 Only “Default” and “Filled” shapes visible in Tableau Public – missing other shape folders

 

 

Hi everyone,

I recently installed Tableau Public (version 2026.1) on my Windows system. The installation is on my D drive, while the “My Tableau Repository” folder is located in my Documents folder on the C drive.

Inside the repository, I can see the Shapes folder, but it is completely empty (no subfolders inside it).

When I try to use shapes in a worksheet:

  • I drag a dimension to the Shape mark
  • Go to Shape → More Shapes

I only see:

  • Default
  • Filled

I do not see other folders like Arrows or Weather that are mentioned in some tutorials.

What I’ve tried:

  • Restarted Tableau Public
  • Confirmed repository path is correct
  • Verified Shapes folder location

Question:

 

Is it normal for Tableau Public to only show “Default” and “Filled” shapes? 

Or am I missing some default shape folders/files?

Also, do I need to manually add custom shapes to use more options?

Any guidance would be appreciated. Thanks! 

 

#Tableau Desktop & Web Authoring  #Tableau Public  #Tableau  #Tableau Community Updates

0/9000