I'm new to Tableau so please forgive my lack of brevity.
I'm trying to build a report to show customers that have purchased a product that they've never purchased before. I have the table of customers and the products they've ordered for the month but I'd like to filter based on if the customer has ordered a new product they've never ordered before, and only show that customer and name of that new product or products.
Can somebody help me identify the correct syntax to use for the calculated field or fields?
3 answers
Use {FIXED [Customer ID], [Product ID] : MIN( [Order Date])} to find the first order date for each customer + product combination. Then you can compare this to the Order Date values to create a flag for these first time orders.
