5 Replies Latest reply on Oct 8, 2013 3:31 PM by philmodjunk

    Trailing Totals - Counting records not values

    SamCohen

      Title

      Trailing Totals - Counting records not values

      Post

           Hello,

            

           I am trying to create a chart. The X axis is week ending date (filed name "Week Ending"). The Y axis has two calculations one that is supposed to count "Human Error Yes" and the other that is supposed to count "Human Error No". These two fields are setup as calculation fields that are supposed to count if the "Human Error" record has a "Yes" or "No" selected. In the table view it is sorting by "Week Ending". The "Human Error" columns are showing a 1 or 0, but the trailing total is counting the number of "Week Ending" date records and not the 1 or 0. How can I get the trialing totals to count the 1's and 0's of the "Human Error Yes" and "Human Error No"???

            

           I hope that was not too confusiing. Let me know if you need any additional information.

           Thanks,

            

           Sam