Tableau Analytics

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.