Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, requirement is to show the Order executions in accumulation for the current month which is Jan 2022. But am getting extra dates greater than today.
Dim : Round(Order_Date - Monthend(Order_Date),1)
Exp 1 : Jan 2022 :
Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today()),'YYYYMM')) } >} Source_Id)
Exp 2 : Dec 2021 :
Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-1),'YYYYMM')) } >} Source_Id)
Exp 3 : Jan 2021 :
Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-12),'YYYYMM')) } >} Source_Id)
Full accumulation, with step 6... if I Use full accumulation with no step then my 2022 Jan line is straight line till the end.
expectation is (last loaded date) 9 - 31(monthend) = -21, current month line chart should stop here it self. but it is going till -14. Please help
@sunny_talwar @Anil_Babu_Samineni @jagan @marcus_sommer @Jonathan_Dienst @Clever_Anjos
@Michael_Tarallo any other expert please provide the inputs.
attaching the sample data.
Findings : when we only keep Jan 2022 expression, then x axis is limited to -20 only. and when we add all the expressions