8 Replies Latest reply on May 1, 2018 1:04 PM by Okechukwu Ossai

    Getting the 2 Most Recent Data Points by ID

    Shawn Schreier

      I would like to be able to get the two most recent data points and compare them but am new to Tableau and having some difficulties.

       

      For example, in my "dummy" file, I have multiple dates where the conversion rate was measured. I want to set up a calculated field that allows me to determine whether the conversion rate went up or down by particular store #. I have tried using the index function but I haven't been able to get that to work the way I need it to. I'm pretty new to Tableau so any assistance/education is greatly appreciated.

       

      In looking at my dummy file, store 1 would indicate the conversion rate increased while store 2 would indicate a decrease.

       

      Thanks,

       

      Shawn