New solution found for finding dormant customers in given date range.
Criteria (summary)
count(formulanumeric: CASE WHEN TO_DATE(‘2022-07-07’, ‘YYYY-MM-DD’)<{transaction.trandate} AND {transaction.trandate}<TO_DATE(‘2022-07-09’, ‘YYYY-MM-DD’) THEN {transaction.internalid} END)”,”equalto”,”0″
We can add other filters as per our requirement
When loading the search, when ever a transaction have made by customer on given date range, it’ll set as count “0“. The customer’s who have count as “0“ will be excluded from the search.