3 Replies Latest reply on Mar 8, 2011 11:57 AM by Mike W

    Calculating Year/Month/Week to date in table with multiple measures

    Mike W

      Hi,

       

      I’m working on a data table in Tableau that has several different measures. I’d like to add in a few columns to my table including prior year, current year to date, prior week, etc. I’ve been researching this topic in the forum for a while, but can’t quite come up with a solution for my case. Most threads deal with applying these date calculations when dealing with only one measure (such as “amount” or “cost”)

       

      My table has several rows worth of measures (cost, clicks, impressions, etc). Any idea how I would apply these types of calculations to all of my measures? I've attached a workbook to illustrate.

       

          Current Year Actuals    - Prior Year to Date - Current Week - Prior Week

      Cost                   

      Clicks                   

      Impressions                   

      Conversions                   

       

       

      Thanks,

      Mike