Forum Discussion

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
5 years ago
Solved

Counting New Customer per day

Dear Concern,   I have date column and customer ID as prvcusID column   I want to find every day how many customer newly created, I attached screen shot  
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    abc_777 

    Make sure, you have only DOE column and add the measure. Check an example below. 

     

  • abc_777's avatar
    abc_777
    5 years ago

    Fowmy 

    perfect I had mistakenly took customer name which I shouldn't.

    Thanks for your support. Really great.

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
5 years ago

Fowmy

I have created measure but resure not as I expected. I want total of each day. like on 2nd of May I have 10 customers newly created or 4th of may I have two customers newly created. screen shot attached

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

abc_777 
Remove PrvCusID column as you need to see by date. 
By keeping only Date and the Count Measure, you can see the number of customers by date, if you add more fields, it will filter by them as well.


  • abc_777's avatar
    abc_777
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    Fowmy 

    thanks for your reply and help but really dont know what happened. I did this as you said removed prvcusid and make this column as count as well as create measure but still bad luck. not sure where the isseu is.

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      abc_777 

      Make sure, you have only DOE column and add the measure. Check an example below. 

       

      • abc_777's avatar
        abc_777
        Icon for Solution Specialist rankSolution Specialist
        5 years ago

        Fowmy 

        perfect I had mistakenly took customer name which I shouldn't.

        Thanks for your support. Really great.