Tableau Analytics

Guest User Core-based licenses of Tableau Server include a Guest user option, which you can use to let people access Tableau views without an account on the server. Guest user access is enabled by default when Tableau Server is installed with a core-based license. It is not available with user-based licensing. If you do not intend to use Guest user access, you should disable it. Guest access allows users only to see and interact with Tableau views. The Guest user cannot browse the Tableau Server interface or see server interface elements in the view, such as user name, account settings, comments, and so on.  Guest user permissions A Guest user can have the following maximum capabilities: Workbooks and views : View, Export Image, Summary Data, View Comments, Filter, Full Data, Web Edit, Download (to save a local copy) Data sources : View and Download If you add the Guest user to a group that has a higher level of access to a content resource, the Guest user’s access does not...

tsm authentication trusted configuration at the command prompt using simple commands Trusted authentication allows shared web link of Tableau report/dashboard to be accessed with login as the trusted mechanism embeds a trusted key in the URL. The key will be valid until the expiry setup in the Tableau server. Configure trusted authentication (trusted tickets) for user authentication on  Tableau Server . Syntax: Go to command prompt on the machine where Tableau server is installed and run the below command with correct variable/options. tsm authentication trusted configure [options] [global options] Ex:  tsm authentication trusted configure -th "192.168.1.101" Here  "192.168.1.101" is web server IP, you can even use web server name here.     Options -th, --hosts <string> Optional. Specifies the trusted host names (or IPv4 addresses) of the web servers that will be hosting pages with Tableau content. For multiple values, enter the names in a comma-...

Sign in to the TSM web UI Remember to use https for TSM web link even of your tableau server uses http Open a browser and enter the Tableau Server URL, and append the dedicated TSM web UI port. Here are some examples of what the URL might look like: https://localhost:8850/  (if you're working directly on the server computer) https://MarketingServer:8850/  (if you know the server's name) https://10.0.0.2:8850/  (if you know the server's IP address) In the sign-in page that appears, enter your administrator user name and password.

Conditionally Formatting Cell Background Color for Individual Measures This is a simple trick to change the cell background color for Tableau measures and you will be excited once you do it. Go to he worksheet where you need to conditional format multiple measures for color background. Drag Measure Values in to the Colors shelf. Change the Marks to Square as shown below: Click on down arrow for the color shelf(on added measure values as shown in the picture below) Select 'Use Seperate Legends" Now you will see the legends for each of the measure t make the life easier to format the color legend for each measure as shown below. Click on each o the color legend and change the legend color and step color to customize individual background of the measures. Repeat the above step for every measure on the Measures Values card to customize the background color.

Embedding Tableau Public Views in iFrame Follow the steps below to embed iframe in a website: Go to the view in Tableau Public.  Select the option "Share" at the bottom of the view and copy the link provided in the Link section.  Add the link in the iframe code. When embedding Tableau Public views in iFrame, the URL must include the following parameters: showVizHome =no  embed =true  The following example shows code that can be used to embed a Tableau Public view in an iFrame, where the source ( src ) is the URL for the view: <iframe src="https://public.tableau.com/views/public_exercise/Dashboard1?:showVizHome=no&:embed=true" width="645" height="955"></iframe> Note:  When you use the view’s URL for the iframe src attribute, do not include the number sign (#) and number at the very end of the URL. Correct src contents: https://public.tableau.com/views/public_exercise/Dashboard1?:showVizHome=no&:embed=true Incorrect src c...

Updating the data in  Tableau Public  dashboard Tableau Public is a free tool to share your visualizations with the world.  One question we often here is how do you refresh data for a Tableau Public visualization.  Tableau Public will do an automatic, nightly refresh data of Google Sheets data, no extra work on your side.   However, there is a bit of additional work required in order to automatically refresh your Google Sheets data.  In our example we are pulling data from a AWS Redshift database using Python. Google Sheets Set-Up This set-up will create the credentials necessary to refresh your Google Sheets data. Create a project in Google Developers Console  https://console.developers.google.com/flows/enableapi?apiid=drive .  Create an account if you have not already done so. Click on Library and search for the Google Drive API, and verify the API is enabled. Next, click on Credentials. Then click on create credentials -> OAuth Client I...

How to add animations to your Tableau vizzes If you already have vizzes saved to your Tableau Public profile, adding animations to your vizzes is easy. Login to Tableau Web Click on a viz in your profile. Click ‘Edit’ to edit the viz in your browser. Click  Format  >  Animations  >  On Save the viz, and close out of web authoring.