8 Replies Latest reply on Nov 8, 2017 3:18 PM by Joe Oppelt

    Question about moving calculations and manipulating table columns

    David Saul

      Hi Tableau Community-


      I am trying to construct a table with about 15 metrics running down the table as rows, with specific moving calculations as columns. The table below is a mockup of what I'd like it to look like.


      Yesterdayvs Last 15 Days Averagevs Last 4 Same Weekdays Average
      Metric 11000x%x%
      Metric 21000x%x%
      Metric 31000x%x%
      Metric 41000x%x%


      I've done a lot of research on this and I'm familiar with LOOKUP functions, WINDOW functions, and table calculations as ways to compute the percent comparisons noted in red in the mock table below. However, the problems I'm running into are:


      • If I use LOOKUP and WINDOW functions in a calculated field, will I need to make a separate calculated field for each metric?
      • In any event, whether I use table calcs or create my own calculated fields, I can only seem to add them to the table as new rows. How can I add these as new columns, with each value lined up with the row for the "parent" metric?


      Thank you in advance for any help. This would be simple to do in Excel, but seems very complicated in Tableau.