3 Replies Latest reply on Sep 19, 2018 5:35 AM by Mahfooj Khan

    Fixed Computations across different Rows (Row order not guaranteed) -- Possible?

    Thomas Rones

      I want to calculate the change in market share for products.

       

      My idea was:

       

      -Get the row where the offset date = the date in the other row
      -Now subtract the market share value in offset date row from the market share value in our date row,

       

      but this didnt work.

       

      Note: There will normally be more than two months, this is a mockup.

       

       

      I know I can do this in the datasource, but having this capability in Tableau would make life so much easier.

       

      The problem is that i don't really understand how calculations are evaluated. I understand the query pipeline, and how the calculations work, but I am unable to understand why this doesn't work. It would be great to be able to do non-view dependent (materialized) calculations where we can decide which rows to use.