8 Replies Latest reply on Nov 28, 2016 3:26 PM by Shinichiro Murakami

    Counting occurrences of value in last X columns

    Frantisek Trenkler



      I have data grouped by week with the Mark being the answer to a question which is a string with various values (Yes, No, N/A, Failed, etc)



      I need to create a field for each row that would count how many times the value of the field was "No" in 6 most recent dates/columns.


      In this example the 6 most recent columns are 10/18 - 11/22,so the result for "General Procedures" would be 1, for "Job Comments" 1 and for "Paperless Billing" 3.


      Any ideas?