Tableau Analytics

Tableau Admin:

Setting date range filter values using a URL parameter.  Create start and end date parameters.  Go to Dashboard > Actions > Add Action > Go to URL... Use the start and end date parameters in your URL. Example: mytableauserver/#/site/sitename/views/workbook/view?Start_Date=<Parameters.Start_Date>&End_Date=<Parameters.End_Date> For more information,  Note: Date (and time) values passed via URL parameter need to match the following Tableau default format:  yyyy-mm-dd hh:mm:ss The desired format can be applied by right-clicking the parameter > Default Properties > Date format... Example URL with paramters:  https://servername.com/views/FandangoRPT?iframeSizedToWindow=true&:embed=y&Sovie_Ftle=Soy%20Sauuce%204%20(2019)&:showAppBanner=false&Start_Date=2019-01-08&End_Date=2020-15-01&%20&:display_count=no&:showVizHome=no&:origin=viz_share_link#8

Creating a Calculation that Ignores Filters Use the level of detail (LOD) expression FIXED .  Follow the steps below: Drag [Region] onto the  Rows  shelf. Drag [Sales] onto  Text  on the marks card. Drag [Category] onto the  Filters  shelf. In the  Edit Filter  dialog, check all categories and click  OK . Right-click [Category] on the  Filters  shelf and select  Show Filter . Select  Analysi s > Create  Calculated Field . In the Calculated Field dialog box that opens, do the following, and then click  OK : Name the calculated field. In this example, the calculated field is named "Unfiltered Sales" In the formula field, create a calculation similar to the following: { FIXED [Region] : SUM( [Sales] ) } Double-click [Unfiltered Sales] in the  Data  pane to add the field to the crosstab.

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.