6 Replies Latest reply on May 11, 2016 2:31 AM by Paul Sherras

    Maximum value for specific group of people only?

    Lotte Kammenga

      Hi,
      So after a customer buys a product, we can send them promotions for other products. The field that I'm looking to create is if a person buys a second product based on a promotion, how long ago did they buy their previous product. So to get that, I need the date of their previous purchase.

      So, in words, the formula I need is

          Give me the largest SaleDate, where count(SaleDate)>1, and where SaleDate<PromotionSendDate

      Is that possible to make as a calculated field? Is 'where' a possible function in Tableau?

      I'm working with version 8.3

      Thanks,
      Lotte