Hello All -
I am a Tableau Public user currently on version 9.2. I have a spreadsheet of customer orders. I would like to create a line graph showing first-time customer orders over time. Ideally, I would be able to show how many first-time customer orders were placed per week over the year. We have many repeat customers and I want to be able to flag just their first order and plot it on the graph in the week that their first order was placed.
Originally I thought I could just create a calculated field based on comparing Min Delivery Date vs Max Delivery Date like this...
"If {FIXED [Customer Name]: MAX([Delivery Date])} = {FIXED [Customer Name]: MIN([Delivery Date])}
THEN "New Order"
End"
But I realized that would give me One-Time customers as opposed to First-Time customers. Any suggestions would be greatly appreciated.
My dataset is attached. Thank you in advance for your help. Cheers!
Chris
Hi Chris-
Try this:
If [Delivery Date] = {Fixed [Customer Name] : Min([Delivery Date])} THEN "First Order" ELSE "Repeat Order" END
