3 Replies Latest reply on Aug 9, 2017 1:39 PM by Ben Neville

    Totals still including filtered data

    Jayson Osmars

      Peculiar thing.

       

      I'm just challenging myself with LOD's for the exam and have ran into a weird thing.

       

      I want to calculate the percentage of customers who have placed repeat orders for 2011 & 2012.

       

      I have the total # of customers, I isolate the customers with orders on both years.  BUT everything I attempt from running_total, to count() to sum/window_sum() etc, are all including the filtered out customers.

       

      I know I must be missing something.  I just wanted others thoughts to approach this dilemma.

       

      Thanks.

       

      PS. It's on version 10.3