5 Replies Latest reply on Nov 1, 2016 11:29 AM by michael petrillo

    Countif on multiple columns & get the result for each row

    SIdhesh Mangle

      Hi All,


      I've tried searching this on forum, But couldn't find anything to do Countif on multiple column measures


      What i want is to check 19 columns with a given a target from a another column & count - How many times value from 19 column was less than target column


      I have data in below excel format, in which Countif(Data range, <Target) - Provides me the count - How many columns are less than target


      Can anyone help me to - How can i do this in Tableau? I think - IFF formula would be too lenghty to use


      It seems very easy in excel, But i am not able to do it in Tableau


      2PLANTargetDay 1Day 2Day 3Day 4Day 5Day 6Day 7Day 8Day 9CountifCountif Formula
      3Beginning Inventory5205144906856856596296055825183=COUNTIF(D3:L3,"<"&C3)