Tableau Analytics

 

  Single-Server Upgrade -- Run Setup Below are the notes from Tableau Site on upgrade to Version: 2020.3.1 Upgrading Tableau Server on Windows from version 2018.1 or older requires special steps that are documented separately. For instructions for how to upgrade from a pre-2018.2 version, see   Upgrade from Tableau Server 2018.1.x or Earlier (Windows) . This topic is part of the Tableau Server in-place upgrade scenario for upgrading from Tableau Server on Windows 2018.2 or later. Run Setup Follow these steps to upgrade a single-node installation of  Tableau Server  version 2018.2 or later. Log onto the computer with an account that is a member of the local administrators group. Navigate to the folder where you copied the Tableau Server Setup program and run it. The Setup program checks system resources to confirm that the computer satisfies the minimum requirements and recommendations. The Setup program displays the location of your existing version and will install the new version sid

Current Year and Last Year Measures Calculation in Tableau. We can achieve this in several ways but according to Tableau KB below are the steps in 2 different ways: Option 1: 1. Drag Year(Order Date) to Columns 2. Create a Calculation that returns sales for this year called  Current year sales:     if YEAR([Order Date])=YEAR(TODAY()) then [Sales] end 3. Create a Calculation that returns sales for last year called  Last year sales:    IF YEAR([Order Date])=YEAR( TODAY())-1 then ([Sales]) end 4. Create a look up calculation called  look up if current year  with following formula:    IF ATTR(YEAR([Order Date])=YEAR(TODAY())) then    LOOKUP(SUM([Sales]),-1) end 5. Drag  look up if current year  to filters and select Special -> Non-null values 6. Hide field labels for columns Option 2: 1. Create a Calculation that returns sales for this year called  Current year sales:     if YEAR([Order Date])=YEAR(TODAY()) then [Sales] end 2. Create a Calculation that returns sales for last year called