1 Reply Latest reply on Apr 5, 2012 2:12 PM by Jonathan Drummey

    Calculate difference between values from different data sources

    Joe Mazzacano

      Tableau file attached - one data source shows sales by day - one data source shows budget by day - need assistance plotting actual and budget by day and calculating difference.

        • 1. Re: Calculate difference between values from different data sources
          Jonathan Drummey

          Hi Joe,

           

          I saw this wasn't answered, hopefully you've figured it out by now. What you need to do is:

           

          - Put Date on the columns shelf and set that pill to be the 2nd Day of Date option. This changes the blue YEAR(Date) pill to a green DAY(Date) pill.

          - Put Measure Values on the Rows shelf and Measure Names on the Color shelf. This draws your lines.

          - In the Sales datasource, create a calculated field that looks like this:

          SUM([Orders])-SUM([budget (2012 budget by day test.xlsx)].[Budget])

          - Then drag the calculated field onto the Measure Values card.

           

          These instructions were performed in the attached workbook.

           

          Jonathan