Tableau Nuggets

  https://www.workout-wednesday.com/

 This is a summary of the steps from Chapter 54 of Innovative Tableau How to make better relative date filters Examples: last 7 days, 30 days, 90 days Create a Set for each and use the Condition tab to dynamically set the range of dates; e.g. [Order Date] >= TODAY() - 7 Use continuous DAY of Order Date Create a Relative Date Range Parameter that has the list of strings with the values and display as. Make the values the same as the Set names (not required but convenient) Create a Relative Date Selection calculated field that will be the Set name based on the value chosen in the Relative Date Range Parameter; e.g. use CASE Place Relative Date Selection calculated field on the FILTER shelf and choose TRUE Create Excel sheet with Display and Value columns to use a "control sheet". Connect to Excel data source and create Text sheet; use will click on Display to select the value which must match the values in the parameter. Create a parameter dashboard action the changes the pa...

 See chapter 95 in Practical Tableau

 Follow these steps in Tableau Desktop: Open Workbook Open View to export to Excel Click Worksheet from top-level menu Click Duplicate as Crosstab  Open crosstab view Click Worksheet,  Export,  Crosstab to Excel from top-level menu Excel will open and you will see the exported data