Forum Discussion
Tracking Customers Year Over Year
Hi,
You have to go to Modelling > New Table and then write that formula in the formula bar.
Great thank you so much, the only thing is am I not able to get a count of returning, new, or infrequent by year?
If I change the Mail # to a count it looks like it turns the whole display chart blank. I would love to be able to take the data and get a count of each of those customer types by year...
Thanks
Hi,
I have done it for new customer only. Please apply the same concept for the others yourself. You may download my PBI file from here.
Hope this helps.
I am trying to do the same thing. How would you account for any duplicate data points that appear?
Hi,
I do not understand your question. Share some data and show the expected result.
In the example you provided you only did New Customers, I just attempted to apply those steps to all customers but my totals do not come out? I had assumed it had to do with duplicated data but maybe I misunderstood your example. Are you able to provide a file with the steps applied to Returning and Infrequent as well?
Hi,
Share some data and show the expected result.
I want to use the same logic the previous poster used. We use "Reservation Number" in place of Mail #. I tried to follow the sample that you provided but you only provided the steps for "New". Can you explain how you apply the logic to Infrequent and Returning?
