Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a raw data table with columns: customer, visit_date, saleswritten_date. Now I want to create a pivot table and put these three columns as three dimensions.
For saleswritten_date, I'm trying to show only those dates not within 7 days of visit_date. For example, for a certain customer:
visit_date 1-10, 1-20
sales_date 1-12,1-18, 1-23, 1-30
Then the result should be like:
-1-10
1-12
-1-20
1-23
Can anybody help me with the formula?
Thanks!
Please share your data or app.
Thank you!
My data as in my example. I'm trying to use the formula:
IF(saleswritten_date>=visit_date+7, DATE(saleswritten_date))
in my 3rd dimension(saleswritten_date dimension). But it doesn't work well.