Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have written an expression, First part of date is showing correct but other part is not getting calculated.
=count(distinct{(< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-2))) & '<=' & date(MonthStart(min(order_processing_date_plan_acv_link),-1))))"}>})>
-(< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-2))) & '<' & date(MonthStart(min(order_processing_date_plan_acv_link),-1))))"}>})>
*
< customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link),-1))) & '<=' & date(MonthStart(min(order_processing_date_plan_acv_link))))"}>})>))
* < customer_key=p ({<order_processing_date_plan_acv_link={"$(= '>='& date(MonthStart(min(order_processing_date_plan_acv_link)))) & '<=' & date(MonthEnd(min(order_processing_date_plan_acv_link))))"}>})>
} customer_key)
Attaching the screenshot of output for the above expression please let me know how get date after '&' , its not getting calculated.
Thanks,
Rajat.
The syntax isn't right - it should be rather look like (simplified):
count({< Date = {">=$(=min(Date))<=$(=max(Date))"}>} Key)