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

       

      ABCDEFGHIJKLMN
      2PLANTargetDay 1Day 2Day 3Day 4Day 5Day 6Day 7Day 8Day 9CountifCountif Formula
      3Beginning Inventory5205144906856856596296055825183=COUNTIF(D3:L3,"<"&C3)
      4Demand102400263024236403=COUNTIF(D4:L4,"<"&C4)
      5DOS303029383736353433321=COUNTIF(D5:L5,"<"&C5)

       

      Regards,

      Sidhesh