7 Replies Latest reply on Jun 20, 2018 7:38 AM by Shinichiro Murakami

    Minifs

    Shawn Suarez

      Hello,

       

      I'm hoping this is a problem that is relatively straightforward, but I haven't found an exact answer to it yet online. What I am trying to do is created a calculated field that acts like the Minifs function in excel. Attached is just a dummy set of data where I have year, store, and score as the column headers. I'd like to calculate the minimum score for each store but before the date listed. Essentially I want to know what each store's minimum score was going into that year.

       

      In excel, that would be the below minifs calculation. But I would like to apply this to a Tableau calculated field, and scale it to larger data.

       

       

      Thanks in advance for any help!

       

       

      Shawn