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).