3 Replies Latest reply on May 23, 2014 6:32 AM by Matt Lutton

    Count First Time Customers by Month

    Steven Levey

      Hi Guys,

       

      I am trying to create a VIZ that shows how many NEW customers have come in, broken down by MONTH. Its easy to show COUNTD([Customer]) but I am trying to see customers that have not previously purchased, making them NEW customers.

       

      I tried using MIN([OrderDate]) along with some other calcs but I cant get a total number of NEW customers by month. I have also tried following a couple other forum posts but just cant seem to get it to work.

       

      I have attached a workbook with as far as I got. Datesource being Sample Store Sales

       

      Would really appreciate some help.

       

      Regards,

      Steven