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


    Shawn Suarez



      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!