Tableau Analytics

Tableau  Error "The load was not able to complete successfully." Opening Workbook According to Tableau this issue occurs due to the  Permissions are preventing Tableau from creating necessary temporary folders, and this error will be logged in  the log.txt: GenerateTempDirectory: failed to create subdirectory in 'C:\Users\user>\AppData\Local\Temp\TableauTemp' Tableau's Resolution Work with your IT team to grant your user account appropriate permissions to the subdirectory specified in the error log.  My Resolution This issue occurred to me when I was trying to open Tableau Hyper workbook with 10.5 version which doesn't support opening the Workbooks created with the version Tableau 2019. So I had to uninstall Tableau 10.5 and made Tableau 2019 as default application to open Tableau, and the issue never occurred.

ShoW NOTHING IN TABLEAU WHEN "ALL" SELECTED Issue: The user wanted to have images (using custom shapes) display on a dashboard when an end user selected an item in a filter, but when they selected "All", then all the images appeared. Instead they didn't want anything to show up (display blank). We couldn't hide the "All" value from the filter, because it was also being used elsewhere on the dashboard where they did want to select all. Work Around: Create a calculated field that counts the number of rows in the view. Then test if this value is greater than 1. To do this I'm using the INDEX() function (which will find out the row number) and then doing a window_sum() of that to get the total number of rows in the view. This creates a boolean (true/false) calculation. We then place this on the filter shelf. We want to include the false or exclude the true. And that's it! There are lots of uses for th...

Replace the NULL values in a measure as N/A in Tableau This looks like  a simple trick but can waste lots of your time if you don't know how to do it as there are no Tableau Tech notes on this.. Steps to replace blank/null values with a Text like 'N/A' Open the workbook. Drag measure into Detail cards. Right click on the measure shown in the details and select Format. You'll see the option for the Last setting which is Special Values(eg. NULL) Enter the desired text like 'N/A' You can see the screenshot below for more details. If you have only two measures in Measure Values, this could get messy fast, so drag another measure onto the Measure Values card for these steps and drag it off when you’re done.

Show header in text for measure names: Use the steps below to show headers for measures: Put Measure Names on the Filters Shelf and choose the measure. Put Measure Names on the Columns Shelf (for a standard column header). Drag Measure Values to wherever you want your measure to go.

Set a Date Filter Default to Max Date in Tableau Some of us might have not noticed the setting a   filter to default to the Max date. There is a quick and simple option to achieve this in Tableau filters. Follow the steps below: 1. Create a date filter with the date dimension. 3. Drag the date dimension to filters pane. 4. Edit the date filter to Select from the list and select the max date available. 2.    Now, y ou have the option  'Filter to latest date value when workbook is opened', check this box and click on OK.

Select Max of Date in Tableau Filter selections Option 1 (Tableau Desktop 10.3 and newer versions) Use the  Latest Date Preset  feature. Unlike the additional options listed below, this option will allow for the use of the filters card to select additional dates. Option 2 Select  Analysis  >  Create Calculated Field . In the Calculated Field dialog box that opens, enter a name for the field. In the formula field, create a calculated field similar to the following: [Order Date] = {FIXED : MAX([Order Date])} Drag the newly created calculated field from the Measures pane to the  Filter  shelf. In the Filter dialog box that opens, select  True ,   and then click  OK .   Option 3 (if LOD calculations are not possible): Select  Analysis  >  Create Calculated Field . In the Calculated Field dialog box that opens, enter a name for the field. In the formula field, create a calculate...

Tableau Unable to Sign In through portal Sign in failed. For help, contact your Tableau Server administrator. {"result":{"guest Enabled":false,"embedded VizForSite Saml Supported":true This happens as the portal from which Tableau is being called as open in new web page. Instead use the tableau report/dashboard in an iFrame, which should take care of the issue. When you embed Tableau Server views into web pages, everyone who visits the page must be a licensed user on Tableau Server. When users visit the page they are prompted to sign in to Tableau Server before they can see the view. If you already have a way of authenticating users on the webpage or within your web application, you can avoid this prompt and save your users from having to sign in twice by setting up trusted authentication. Trusted authentication simply means that you have set up a trusted relationship between Tableau Server and one or more web servers. When Tableau Server...