14 Replies Latest reply on Oct 13, 2017 1:16 AM by Xavier De Coster

    Lowest price for latest day

    Xavier De Coster

      Hello all, first time poster here.

       

      I'm trying to do what seemed like an easy calculated field, I need, for a given triplet ( [Level1],[Level2],[Level3] ) to find the lowest price of the latest day:

       

      Level 1Level 2Level 3DatePrice
      HondaCarRed02/06/201710000
      HondaMotorcycleBlue02/06/20175000
      BMWCarRed02/06/201715000
      BMWCarRed03/06/201712000
      BMWCarRed03/06/201711000
      BMWCarBlue02/06/20177500

       

       

      With the above example I would have liked to find the following values (especially the one in orange)

       

      HondaCarRed02/06/201710000
      HondaMotorcycleBlue02/06/20175000
      BMWCarRed03/06/201711000
      BMWCarBlue02/06/20177500

       

      I was thinking of using the following formula but it isn't working as I was hoping:

      {FIXED [Level1],[Level2],[Level3], {FIXED [Level1],[Level2],[Level3]: MAX([Date])}: MIN(Price)}

       

      I'm new to Tableau and I feel like I migh be missing a concept.

       

      Any help is welcome