Forum Discussion
Measure Filtering Scenario
JustSayJoe share the sample data and the expected output.
Date Order ID Email Address Product 8/1/2023 1 [email protected] Thing1 8/2/2023 2 [email protected] Thing2 8/3/2023 3 [email protected] Thing3 8/4/2023 4 [email protected] Thing4 8/5/2023 5 [email protected] Thing5 8/6/2023 6 [email protected] Thing1 8/7/2023 7 [email protected] Thing2 Expected Outcome of the [Returning Customers] Measure...
When I filter my page by Product for "Thing1", the Returning Customers should be 0.When I filter my page by Product for "Thing2", the Returning Customers should be 0.
When I filter my page by Product for "Thing3", the Returning Customers should be 1 (because [email protected] previously purchased another Product on 8/1/2023).
When I filter my page by Product for "Thing4", the Returning Customers should be 0 (even though [email protected] has purchased two different products, Thing4 was their first purchased product, so they were not a returning customer yet).
When I filter my page by Product for "Thing5", the Returning Customers should be 1 (because [email protected] previously purchased another Product on 8/4/2023).
